asked on

MSquery - ODBC - CSV : Delimiter not recognized

On my PC, when I use "New Database Query" from Excel 2003, I can make a query with a CSV file (semi-colon delimited).

When I use the same method on an another PC, MS Query can't recognize the semi-colon delimiter. It sees only one field. The regional settings are the same (separator value = semi-colon), the versions of the ODBC driver are the same. How can I resolve this problem ?

FYI : I have also made a test with an ODBC connection with Open Office Base and I have the same problem. On my PC it's OK and on the other PC not !

sah18

I'm not sure why the inconsistency between the two systems, but here's something you could try. Try renaming the extension from .csv to .txt and see if you have any better results. Technically, a "csv" file stands for "comma separate values", and that isn't what you have -- you have semi-colon separated values. This may or may not be the cause of the issue, but it's worth a try. Let me know the results!

Andrew

Could you possibly post a sample of your file to enable greater investigation to take place?

ltlbearand3

Just a some random thoughts to try:

1. Are the schema.ini files the same?
2. What happens if you open the CSV file directly - does it open properly on both PCs.
3. In Open Office Calc, do a file open and find the file and see if it can open it properly.

-Bear

Phve_364

ASKER

You will find below the answers to your questions:

I have renamed the csv file to txt : same problem

I don't use schema.ini files

If I double click on this csv file, Excel opens this file properly on both PCs

If I open this file with Open Office Calc, a wizard appears and I must choose the separator (on the 2 PCs)

test.csv

ASKER CERTIFIED SOLUTION

Phve_364

membership

This solution is only available to members.