Converting an Excel Spreadsheet to an Access 2007 Database

By Mike Chapple, About.com Guide

You'll see an intermediate screen asking you if you'd like to save the steps used to import your data. If not, go ahead and click the Close button.

You'll then be returned to the main database screen where you can view your data by simply double-clicking on the table name in the left panel. Congratulations, you've successfully imported your data from Excel into Access!

Previous

• 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

Next