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.
REFERENCES
For more information about importing text files, search the Help Index
for "Importing data," or ask the Microsoft Access 97 Office Assistant.
Keywords: kbprb kbusage KB152049