What wrong is it-please help?

  • Thread starter Thread starter TA
  • Start date Start date
T

TA

Dear All,
Here is my command:
DoCmd.TransferText
acImportDelim, , "dbo_cumupdate", "C:\Access Projects\Text
Files\Update.txt"

Here is error :

"Field 'F1' doesn't exist in destination table
dbo_cumupdate" - Any advice?
The link table dbo_cumupdate have a field name set to
autonumber and it is a primary key.
Any advise?
Best Regards,
TA
 
Case "ASCII Delim"
DoCmd.TransferText acImportDelim, strSpecName, strTableName,
Me![txtLocalDir] & Me![txtLocalFileName], True

You are missing 2 pieces of the command.
You need to build a specification and save it and then use it in your code.
Also, the last setting of True means the first row has column names.
 
Back
Top