If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Files saved as csv files are actually saved as text files?
I am opening txt files in Excel, importing them using the wizard and then
saving them as csv files for use in another application. However the upload into the other application fails. When I check the csv file in Excel it all looks fine but if I open it in notepad I can see that it is not comma separated but is using semi-colons (a good indicator that it is being saved as a txt file). How can I get Excel to save it as a proper csv file? I am using Excel 2000 |
#2
|
|||
|
|||
Files saved as csv files are actually saved as text files?
Try changing your windows list separator to a comma.
In WinXP Home, it's under the control panel|regional and language options applet. Click on the Customize button in the Regional Options tab Then change that list separator on the Numbers tab. Be aware that this is a windows setting and may affect other stuff. Queen_Of_Thebes wrote: I am opening txt files in Excel, importing them using the wizard and then saving them as csv files for use in another application. However the upload into the other application fails. When I check the csv file in Excel it all looks fine but if I open it in notepad I can see that it is not comma separated but is using semi-colons (a good indicator that it is being saved as a txt file). How can I get Excel to save it as a proper csv file? I am using Excel 2000 -- Dave Peterson |
#3
|
|||
|
|||
Files saved as csv files are actually saved as text files?
If you look in Windows Regional Options (in Control Panel), what do you have
as the list separator? -- David Biddulph "Queen_Of_Thebes" wrote in message ... I am opening txt files in Excel, importing them using the wizard and then saving them as csv files for use in another application. However the upload into the other application fails. When I check the csv file in Excel it all looks fine but if I open it in notepad I can see that it is not comma separated but is using semi-colons (a good indicator that it is being saved as a txt file). How can I get Excel to save it as a proper csv file? I am using Excel 2000 |
Thread Tools | |
Display Modes | |
|
|