Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...

[Regnab]

I'm automating the import of all text files into Access from a source
folder. I was getting the "Field 'F1' doesn't exist in destination
table" error, so I checked it out on the net and it said to create a
import specification. So I did this (InductionImport), and included it
in my code as below:

DoCmd.TransferText acImportDelim, InductionImport,
"ImportedInductionLots", CurrentPath & strfile, 0

I created the import specs as per Microsoft's explanation:
http://support.microsoft.com/default...b;EN-US;142186

I'm at a loss as to how to fix it... except just calling the field
names F1 - F12 and renaming them later (which is a lot of mucking
around and a bit untidy). From what I understand, this Spec should
rename the fields as they are imported to match the names in the table.
And when I did it manually, it worked...

All ideas appreciated...

Cheers

Reg

[pietlinden]

DoCmd.TransferText acImportDelim, "MAIN Import Specification", "MAIN",
strFileToImport, True

Based on one I have that works, this is what I think is wrong - the
order of your arguments is wrong.

the second argument should be in quotes (the name of the import
specification). That should fix it. No, the import spec does not
rename any fields, it just maps values in the CSV file to the table.

[pietlinden]

DoCmd.TransferText acImportDelim, "MAIN Import Specification", "MAIN",
strFileToImport, True

Based on one I have that works, this is what I think is wrong - the
order of your arguments is wrong.

the second argument should be in quotes (the name of the import
specification). That should fix it. No, the import spec does not
rename any fields, it just maps values in the CSV file to the table.

[Regnab]

Thankyou... works a charm.... excellent....

[Regnab]

Thankyou... works a charm.... excellent....