TransferText Problems

[Elvis]

I am trying to transfer some text from a delimited text file into a table named "Audit". If I manually import the textfile everything works ok. I have coded a button to do the same thing without having to go through the whole manual thing, however it does not work. I changed the acImportDelim to acExportDelim, executed the button and the file gets exported, I then changed acExportDelim back to Import and ran again. I now get the following error message:

Field 'Field1' doesn't exist in destination table 'Audit.'

This is the command I have coded to perform the Import

DoCmd.TransferText acImportDelim, ,"Audit", "C:\documents and settings\temptxt\ukdev1_export.txt", False

Any help would be most appreciated

 

[___]

When going through the import wizard, click on Advanced, here you can name your fields and save. Then place your saved import spec in the command line...

DoCmd.TransferText acImportDelim, "YourSavedImportSpec", "Audit", "C:\documents and settings\temptxt\ukdev1_export.txt", False

HTH