Converting an Excel Spreadsheet to an Access 2010 Database

By Mike Chapple, About.com Guide

Unless you have an existing database that you use to store contact information, you're probably going to want to create a new database from scratch. To do this, click on the Blank Database icon on the Getting Started with Microsoft Office Access screen. You'll be presented with the screen above. Provide your database with a name, click the Create button and you'll be in business.

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