Converting an Excel Spreadsheet to an Access 2010 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.

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