Auto import from text file (2003)

Topic

New Reply

There are one text file that need to be imported daily with import specs already in the database. Here is what I am doing now:

I need to Import text file – Import – Advanced – Specs (choose Test structure) – Next – Next – Next – No Primary Key – create tbl_test table.

I have tried the following codes, but I got import error table with “Conversation error” and all blank valume in tbl_test table.

DoCmd.TransferText acImportDelim, “Test”, “tbl_test”, “c:test.txt”

So why the codes were not working?

Thanks in advance.

Reply | Quote

Replies

Without seeing a representative sample of the text file it’s impossible to say (assuming that your import specification is really named “Test” and not “Test structure”).

Does Access create an Import Errors table when the import fails? If so, do the records in this table give a clue?

Reply | Quote