VBA Access Import Specification strange error

Question

I am trying to import a text file into Access using a saved "Import Specification" in my access database using VBA. The import generates the Import Error table showing the errors in the last two fields. BUT if I use the same import specification manually to import the text file, the Import works perfect !!!!! Strange ..... why would they have different behavior ?

Here is the database and the text file

http://www.box.net/shared/ro7n3b7a77

Answer 1

Sorry, my bad.

The command in VBA should have been

DoCmd.TransferText acImportDelim, "Import Specification", strCurrentTable, strDocPath & strCurrentFile

Use "acImportDelim" instead of "acImportFixed"