ACC: Text Import Wizard Allows Only One Field for Primary Key (152049)


The information in this article applies to:

  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
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.
Modification Type:MajorLast Reviewed:10/31/2003
Keywords:kbprb kbusage KB152049
©2003 Microsoft Corporation. All rights reserved.