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:
- 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.
- On the File menu, point to Get External Data, and then click Import.
- In the Import dialog box, select Text Files. Locate and select your delimited text file, and then click Import.
- In the Import Text Wizard, click Advanced.
- 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.
- Click OK to close the Specification Name dialog box.
- In the Import Text Wizard, click Cancel.
To use the import specification, follow these steps:
- Open the macro or Visual Basic procedure containing the TransferText action or method in Design view.
- 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
DoCmd.TransferText acImportDelim, <specification name>, _
<table name>, <filename path>, 0