Converting an Excel Spreadsheet to an Access 2007 Database
By Mike Chapple, About.com
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
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.