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