When you import a text file by using the TransferText method or action with an import specification that applies indexes to a field, the resulting table does not contain the expected indexes.

Import the text file by using the Import Text Wizard and the appropriate import specification so that the expected indexes appear in the resulting table.

Steps to Reproduce Behavior

1. Start Microsoft Access, and then open the sample database Northwind.mdb.
2. Export the Shippers table to a tab-delimited text file named Shippers.txt in the root directory of drive C. Click to select the Include Field Names on First Row check box.
3. On the File menu, point to Get External Data, and then click Import.
4. In the Import dialog box, click Text Files in the Files of type box; then, locate and double-click the Shippers.txt file on drive C.
5. On the first screen of the Import Text Wizard, click Delimited, and then click Next.
6. When asked to choose a delimiter, click Tab. Click to select the First Row Contains Field Names check box, and then click Next twice.
7. On the Field Options screen, click the ShipperID field, and then click Yes (No Duplicates) in the Indexed box. Click Next.
8. On the Primary Key screen, click Choose my own primary key, click ShipperID, and then click Next.
9. On the last screen of the Import Text Wizard, click Advanced.
10. In the Shippers Import Specification dialog box, click Save As.
11. In the Save Import/Export Specification dialog box, type Shippers Spec, and then click OK.
12. In the Shippers Spec dialog box, click OK.
13. Back on the last screen of the Import Text Wizard, type Shippers1 in the Import to Table box, and then click Finish.
14. Open the Shippers1 table in Design view, and note that the ShipperID field is the primary key.

To use the TransferText action to import the Shippers.txt file, follow these steps:

1. In the Database window, click the Macros tab, and then click New.
2. Create the following macro named mcrTestMacro:
   Action
   TransferText
   
   TransferText Action Arguments
   Transfer Type: Import Delimited
   Specification Name: Shippers Spec
   Table Name: Shippers2
   File Name: C:\Shippers.txt
   Has Field Names: Yes
3. Save the macro as mcrTextMacro.
4. Run the macro, and then close it.
5. Open the Shippers2 table in Design view, and note that it does not contain a primary key.
6. On the View menu, click Indexes. Note that the ShipperID field appears on the list of indexes, but its Unique property is set to No.