Converting an Excel Spreadsheet to an Access 2007 Database
By Mike Chapple, About.com Guide
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.
Prev
- Prepare Your Data
- Create a New Access 2007 Database
- Begin the Excel Import Process
- Select the Source and Destination
- Select Column Headings
- Create Any Desired Indexes
- Select a Primary Key
- Name Your Table
- View Your Data
Explore Databases
Must Reads
About.com Special Features
Holiday Central
What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >
Family Tech Center
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.