Converting an Excel Spreadsheet to an Access 2007 Database

Select a Primary Key

The primary key is used to uniquely identify records in a database. The easiest way to do this is to let Access generate a primary key for you. Select the "Let Access add primary key" option and press Next to continue. If you're interested in choosing your own primary key, you might want to read our article on database keys.