Microsoft KB Archive/208422

= ACC2000: Text Import Wizard Allows Only One Field for Primary Key =

Article ID: 208422

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208422



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you import a text file, one of the options in the Import Text Wizard is the Choose my own primary key option. However, this option allows you to select only one field for a primary key.



RESOLUTION
If you need a multiple-key index, select the No primary key option when you use the Import Text Wizard. After the import is completed, open the table in Design view, select the fields that you want for your primary key, and then click the Primary Key button on the Table Design toolbar.

