Excel 2003 doesn't convert CSV files with commas, only with semicolons

[Guest]

Dear Users

Does anyone know a workaround? I need to convert a lot of CSV files, which uses commas instead of semicolons. The basic format requirement of an Excell CSV uses semicolons. The previous versions (Excell 2000 for sure) were able to convert CSV files with commas instead of semicolons. X2003 cannot: it does convert the text, but will put an entire line including all commas into a single cell

Thank you for your valuable help in advance

Best regards
Aron ECSED

PS: It is rather interesting that a CSV file was redefined by MS as "SSV" (Comma Separated Values should use commas and not semicolons)..

 

[BrianB]

1. I cannot see how Microsoft can redefine CSV because this is a
international standard. You do not say which country you are in. It ma
be that your country uses a different standard - hence the change i
possible.

2. I am in the UK where the standard is to use a comma. One workroun
might be to change your global settings via Control Panel.

3. Another workround would be to rename your files with a .txt suffi
instead of .csv and use Excel File/Open when you will get the option t
use the delimiter of your choice.

4. .. or use this macro :-

'-----------------------------------------------------------------
Sub Macro1()
Workbooks.OpenText FileName:="book1.csv", _
DataType:=xlDelimited, comma:=True
End Sub
'-----------------------------------------------------------------

 

[Joerg Eisentraeger]

Does anyone know a workaround?

Use this:
http://www.cpearson.com/excel/imptext.htm


Greatings from Germany
Joerg