Converting an Excel Spreadsheet to an Access 2007 Database
By Mike Chapple, About.com Guide
You need to provide Access with a name to reference your table. We'll call our table "Contacts." Enter this into the appropriate field and click on the Finish button.
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.