Microsoft KB Archive/152049

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

Article ID: 152049

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q152049



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



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 will allow 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. Once the import is completed, open the table in Design view, select the fields you want for your primary key, and then click the Key button on the toolbar.

