Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing CSV files | Excel Discussion (Misc queries) | |||
Importing txt files one character per column/row. | Excel Discussion (Misc queries) | |||
Importing files | Excel Discussion (Misc queries) | |||
Importing CSV files | Excel Discussion (Misc queries) | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) |