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.
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>'.
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.
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:
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.
Contact us for more help
Connect with Answer Desk for expert help.