External Data: Primary Key The original data in the Excel spreadsheet did not have a unique number for each record. It is not indexed, yet. This step creates a Primary Key.   7. Try it: Create a Primary Key The Import Wizard is on step 5. There is a new First Column, ID. What Do You See? The Import Wizard offers three choices for the Primary Key: Let Access add primary key Choose my own primary key No primary key.   Select an option: Let Access add primary key   Click Next. Keep going... External Data ->Import & Link->Excel Exam 77-885: Microsoft Access 2010 2. Building Tables 2.5. Import data from a single data file: Import into a New Table