Problems with Transfer Text Action

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am trying to load a .txt file into my access database
and am experiencing problems. I load the file in via the
import wizard each day and have no problems, however, I
have not yet been able to do it successfully via a macro.

My setting are as follows:
Transfer Type: Import Delimited
Specification Name:
Table Name: Declarations
File Name: C:\Program Files\Raceform
Interactive\Export\Declarations.txt
Has Field Names: No
HTML Table Name:
Code Page:

When I run the macro I get the following message:
Field 'F1' doesn't exist in destination
table 'Declarations'. Microsoft Office was unable to
complete the append operation. The destination table
must contain the same fields as the table you are pasting
from.

Any ideas what I may be doing wrong ? Remember, I have
no problems when importing manually.

Thanks in advance
Steve
 
Steve

Run through the import wizard again, and when you get to the last sceen,
click the Advanced button, and save the set up as a Specification.
Then, nominate this specification in the Specification Name argument of
your TransferText macro.
 
Back
Top