Converting an Excel Spreadsheet to an Access 2010 Database

By Mike Chapple, About.com Guide

Next, you'll be presented with the screen shown above. Click the Browse button and navigate to the file you'd like to import. Once you've located the correct file, click the Open button.

On the bottom half of the screen, you're presented with import destination options. In this tutorial, we're interested in converting an existing Excel spreadsheet to a new Access database, so we'll choose "Import the source data into a new table in the current database."

Other options on this screen allow you to:

• Link your database to an Excel sheet so that changes in the source sheet are reflected in the database
• Import data into an existing database table

Once you've selected the correct file and option, click the OK button to continue.

Previous

• Prepare Your Data
• Create a New Access 2010 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