Microsoft KB Archive/182002

= ACC97: TransferText Ignores Indexes in Import Specification =

Article ID: 182002

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q182002



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
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.



RESOLUTION
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.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Export the Shippers table to a tab delimited text file named Shippers.txt to drive C. Be sure to select the Include Field Names in First Row check box.
 * 3) On the File menu, point to Get External Data, and click Import.
 * 4) In the Import dialog box, click Text Files in the Files Of Type box; then locate the Shippers.txt file on drive C and double-click it.
 * 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. Then select the First Row Contains Field Names check box and click Next twice.
 * 7) On the Field Options screen, click the ShipperID field and select Yes (No Duplicates) in the Indexed box. Click Next.
 * 8) In the Primary Key screen, click Choose My Own Primary Key and select ShipperID. 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 . Click OK.
 * 12) In the Shippers Spec dialog box, click OK.
 * 13) On the last screen of the Import Text Wizard, type Shippers1 in the Import To Table box. Click Finish.
 * 14) Open the Shippers1 table in Design view and note that the ShipperID field is the primary key.

Follow these steps to use the TransferText action to import the Shippers.txt file.

 In the Database window, select the Macros tab, and then click New.  Create the following macro named mcrTestMacro:

     Action TransferText

TransferText Actions -     Transfer Type: Import Delimited Specification Name: Shippers Spec Table Name: Shippers2 File Name: C:\Shippers.txt Has Field Names: Yes  Save the macro as mcrTextMacro. Run the macro, and then close it. Open the Shippers2 table in Design view and note that it does not contain a primary key.</li> 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.</li></ol>

Additional query words: importing

Keywords: kbbug kbpending KB182002

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.