Converting an Excel Spreadsheet to an Access 2010 Database

By Mike Chapple, About.com Guide

Often, Microsoft Excel users utilize the first row of their spreadsheet to provide column names for their data. In our example file, we did this to identify the Last Name, First Name, Address, etc. columns. In the window shown above, ensure that the "First Row Contains Column Headings" box is checked. This will instruct Access to treat the first row as names, rather than actual data to be stored in the list of contacts. Click the Next 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