ACC: "Field 'F1' Doesn't Exist in Destination Table" Error MsgLast reviewed: May 7, 1997Article ID: Q142186 |
The information in this article applies to:
SYMPTOMSAdvanced: Requires expert coding, interoperability, and multiuser skills. When you append data to an existing table from a delimited text file using a TransferText macro action or a TransferText method in Visual Basic for Applications, you may receive the following error message:
Field 'F1' doesn't exist in destination table '<table>'. Microsoft Access was unable to append it. The destination table must contain the same fields as the table you are pasting from. CAUSEThe first row of the text file does not contain field names; therefore, Microsoft Access assumes the fields are called "F1," "F2," and so on.
RESOLUTIONYou can create and use an import specification to identify the fields in the delimited text file. To create an import specification, follow these steps:
REFERENCESFor more information about transferring text using a macro or Visual Basic for Applications, search on the phrase "transfertext," and then view "Automate importing, exporting, or linking of data" using the Office Assistant. |
Keywords : IsmTxtd kberrmsg kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |