importing csv files- entire record goes into each column
 

This used to work before but now whenever I import a .csv file (I've
tried each one that used to work before) entire records are being put
into each column variable but the commas are still there. There must be
a setting for this (looks like it doesn't recognize the comma any more)
but darned if I can find it. I went into control panel and
Regional/Laguages-- Customize and it already said that the separator
char was a comma...

Anyplace else I can check?

thanks,
Bill

importing csv files- entire record goes into each column
 

Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to the
file and this will open the text import wizard, you can set the delimiter as
comma via this route

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Bill" wrote in message
...
This used to work before but now whenever I import a .csv file (I've tried
each one that used to work before) entire records are being put into each
column variable but the commas are still there. There must be a setting
for this (looks like it doesn't recognize the comma any more)
but darned if I can find it. I went into control panel and
Regional/Laguages-- Customize and it already said that the separator
char was a comma...

Anyplace else I can check?

thanks,
Bill

importing csv files- entire record goes into each column
 

Thanks Nick-

I should have mentioned that our new student records syetm (SCT
Banner) is tossing the file (via IE) into Excel, so we actaully Can't (
[=]8 ) remove the ".csv" file extension. I tried deleting it from the
'filetypes' section of the control panel 'folders' menu and the
'custom' section of "regional language" but everything appears to be
set correctly and this is the only pc with the problem. It's not a huge
thing but not being able to find the reason bugs me. . . .it's almost as
if it doesn't recognize the "," as the separator. . .

thanks for the reply!
Bill

Nick Hodge wrote:
Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to the
file and this will open the text import wizard, you can set the
delimiter as comma via this route

importing csv files- entire record goes into each column
 

Could it be that the windows regional setting list separator is set to something
else (a semicolon is common in parts of the world).

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box.

Bill wrote:

Thanks Nick-

I should have mentioned that our new student records syetm (SCT
Banner) is tossing the file (via IE) into Excel, so we actaully Can't (
[=]8 ) remove the ".csv" file extension. I tried deleting it from the
'filetypes' section of the control panel 'folders' menu and the
'custom' section of "regional language" but everything appears to be
set correctly and this is the only pc with the problem. It's not a huge
thing but not being able to find the reason bugs me. . . .it's almost as
if it doesn't recognize the "," as the separator. . .

thanks for the reply!
Bill

Nick Hodge wrote:
Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to the
file and this will open the text import wizard, you can set the
delimiter as comma via this route


--

Dave Peterson

importing csv files- entire record goes into each column
 

From the OP:
"I went into control panel and Regional/Laguages-- Customize and it already
said that the separator char was a comma..."
--
David Biddulph

"Dave Peterson" wrote in message
...
Could it be that the windows regional setting list separator is set to
something
else (a semicolon is common in parts of the world).

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box.

Bill wrote:

Thanks Nick-

I should have mentioned that our new student records syetm (SCT
Banner) is tossing the file (via IE) into Excel, so we actaully Can't (
[=]8 ) remove the ".csv" file extension. I tried deleting it from the
'filetypes' section of the control panel 'folders' menu and the
'custom' section of "regional language" but everything appears to be
set correctly and this is the only pc with the problem. It's not a huge
thing but not being able to find the reason bugs me. . . .it's almost as
if it doesn't recognize the "," as the separator. . .

thanks for the reply!
Bill

Nick Hodge wrote:
Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to
the
file and this will open the text import wizard, you can set the
delimiter as comma via this route


--

Dave Peterson

importing csv files- entire record goes into each column
 

(XL2002/3) Try Tools Options and navigate to the International tab .
In the number handling section make sure the "use system separators"
option is checked.

As Dave mentioned if the decimal separator is set to comma as is
common in much of Europe and elsewhere, the default separator for csv
files, function arguments and arrays becomes a semicolon.


On 26 Mar, 16:28, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
From the OP:
"I went into control panel and Regional/Laguages-- Customize and it already
said that the separator char was a comma..."
--
David Biddulph

"Dave Peterson" wrote in message

...



Could it be that the windows regional setting list separator is set to
something
else (a semicolon is common in parts of the world).

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box.

Bill wrote:

Thanks Nick-

I should have mentioned that our new student records syetm (SCT
Banner) is tossing the file (via IE) into Excel, so we actaully Can't (
[=]8 ) remove the ".csv" file extension. I tried deleting it from the
'filetypes' section of the control panel 'folders' menu and the
'custom' section of "regional language" but everything appears to be
set correctly and this is the only pc with the problem. It's not a huge
thing but not being able to find the reason bugs me. . . .it's almost as
if it doesn't recognize the "," as the separator. . .

thanks for the reply!
Bill

Nick Hodge wrote:
Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to
the
file and this will open the text import wizard, you can set the
delimiter as comma via this route

--

Dave Peterson- Hide quoted text -

- Show quoted text -

importing csv files- entire record goes into each column
 

I didn't go back to the original post--and it was snipped from the previous
response.

David Biddulph wrote:

From the OP:
"I went into control panel and Regional/Laguages-- Customize and it already
said that the separator char was a comma..."
--
David Biddulph

"Dave Peterson" wrote in message
...
Could it be that the windows regional setting list separator is set to
something
else (a semicolon is common in parts of the world).

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box.

Bill wrote:

Thanks Nick-

I should have mentioned that our new student records syetm (SCT
Banner) is tossing the file (via IE) into Excel, so we actaully Can't (
[=]8 ) remove the ".csv" file extension. I tried deleting it from the
'filetypes' section of the control panel 'folders' menu and the
'custom' section of "regional language" but everything appears to be
set correctly and this is the only pc with the problem. It's not a huge
thing but not being able to find the reason bugs me. . . .it's almost as
if it doesn't recognize the "," as the separator. . .

thanks for the reply!
Bill

Nick Hodge wrote:
Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to
the
file and this will open the text import wizard, you can set the
delimiter as comma via this route


--

Dave Peterson

--

Dave Peterson

importing csv files- entire record goes into each column
 

Hi,

I think your current selecion is just a cell in cell A1, before downloading.
Select all
columns by clicking the left corner - Above row 1 and left of column A - and
then try downloading again. This will display all the data as stored in the
CSV file.

Note: Although the source file may be delimited, you are just specifying a
single cell as selection for importing data, therefore, Microsoft Excel
assumes that you want to import all your data only into that particular cell.

Challa Prabhu


"Bill" wrote:

This used to work before but now whenever I import a .csv file (I've
tried each one that used to work before) entire records are being put
into each column variable but the commas are still there. There must be
a setting for this (looks like it doesn't recognize the comma any more)
but darned if I can find it. I went into control panel and
Regional/Laguages-- Customize and it already said that the separator
char was a comma...

Anyplace else I can check?

thanks,
Bill