importing csv files- entire record goes into each column

[Bill]

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

 

[Nick Hodge]

Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to Files>Open...> 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
[email protected]
www.nickhodge.co.uk

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

 

[Bill]

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

 

[Dave Peterson]

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

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

Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to Files>Open...> 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

 

[David Biddulph]

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

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

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

Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to Files>Open...> 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

 

[Lori]

(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.

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

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 Files>Open...> 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 -

 

[Dave Peterson]

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

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

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

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 Files>Open...> 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

 

[challa prabhu]

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