Q
Queen_Of_Thebes
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
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