Converting an Excel Spreadsheet to an Access 2007 Database
By Mike Chapple, About.com
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
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.