Converting an Excel Spreadsheet to an Access 2007 Database
By Mike Chapple, About.com Guide
Next, click the External Data tab at the top of the Access screen and double-click the Excel button to begin the Excel import process. The position of this button is indicated by the red arrow in the image above.
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.