ACC2000: Text Import Wizard Allows Only One Field for Primary Key (208422)


The information in this article applies to:

  • Microsoft Access 2000
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.

REFERENCES

For more information about importing data, click Microsoft Access Help on the Help menu, type import data in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/30/2004
Keywords:kbprb kbusage KB208422
©2004 Microsoft Corporation. All rights reserved.