*.csv file import problem (1 Viewer)

[Danielf]

Hi,

I have a *.csv file with 7 fields delimited by 6 commas . The code to import the file in a table should be :

DoCmd.TransferText acImportDelim, , "abc", "c:\abc.csv".

The problem is that I can import my *.csv file but in my new table , I have only one field "F1" with all my data (with commas) in that field.

What is wrong? I would like to have 7 fields in my table, like in my csv file.

Thanks for answer.

Daniel

 

[Geoff Codd]

create an import specification and name that in you import code

 

[Danielf]

Thanks it works

Daniel