Importing a part of a big comma delimited csv-file

S

smari

When I use New database query -funtion and having a semi-colon delimited
csv-file, everything works fine, I can make a qeury and use criterias.
When a csv-file is comma delimited, MS Query can not recognize comma
delimited fields, it sees only a one filed. I tried to change the list
separator value in Regional options from semi-colom to comma, but it did not
make a difference.
I'm using Office 2003.
Is this possible somehow?

-smari
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a ASCII semi-colon or comma delimited file 2
Macro that converts xls to csv 0
change csv list separator in excel 2007 Dutch version 1
CSV-file as semicolon se 2
Workbook.SaveAs method save incorrect CSV file - French XP and Off 7
Export Access Query to a pipe delimited .csv file 5
Access import CSV file with comma issue 5
Printing envelopes using a CSV mail file 1

Top