ACC2000: "Field 'F1' Doesn't Exist in Destination Table" Error Message

Article translations Article translations
Article ID: 208582 - View products that this article applies to.
This article was previously published under Q208582
Advanced: Requires expert coding, interoperability, and multiuser skills.

Expand all | Collapse all

SYMPTOMS

When you append data from a delimited text file to an existing table by using a TransferText macro action or a TransferText method in Visual Basic for Applications, you may receive an error message similar to the following:
Run-time error '2391':
Field 'F1' doesn't exist in destination table '<table name>'.

CAUSE

The first row of the text file does not contain field names; therefore, Microsoft Access assumes the fields are named "F1," "F2," and so on.

RESOLUTION

You can create and use an import specification to identify the fields in the delimited text file.

To create an import specification, follow these steps:
  1. In the Database window, select the table into which to append data using a TransferText macro action or a TransferText method in Visual Basic for Applications.
  2. On the File menu, point to Get External Data, and then click Import.
  3. In the Import dialog box, select Text Files. Locate and select your delimited text file, and then click Import.
  4. In the Import Text Wizard, click Advanced.
  5. In the 'NameOfFile' Import Specification dialog box, type the correct field names for the fields in the Field Name column, and then click Save As. Type a specification name and click OK.
  6. Click OK to close the Specification Name dialog box.
  7. In the Import Text Wizard, click Cancel.
To use the import specification, follow these steps:
  1. Open the macro or Visual Basic procedure containing the TransferText action or method in Design view.
  2. Modify the action or method to include a Specification Name argument. For example:

    In a Macro:
       TransferText Actions
          Transfer Type: Import Delimited
          Specification Name: <specification name>
          Table Name: <table name>
          File Name: <full path>
          Has Field Names: No
    						
    In Visual Basic for Applications:
    DoCmd.TransferText acImportDelim, <specification name>, _
      <table name>, <filename path>, 0
    					

REFERENCES

For more information about transferring text by using a macro or Visual Basic for Applications, click Microsoft Access Help on the Help menu, type TransferText in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Properties

Article ID: 208582 - Last Review: July 13, 2004 - Revision: 1.1
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kberrmsg kbprb KB208582

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com