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