You are here:About>Computing & Technology>Databases> Microsoft Access> Tutorials> Converting an Excel Spreadsheet to an Access 2007 Database
About.comDatabases
Newsletters & RSSEmail to a friendSubmit to Digg

Converting an Excel Spreadsheet to an Access 2007 Database

From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Prepare Your Data

Sample Excel Database
Mike Chapple
Previous | Next >>
After sending out your holiday cards last year, did you make yourself a promise that you would organize your address list to make the process easier next year? Do you have a huge Excel spreadsheet that you can't make heads or tails of? Maybe your address book looks something like the one shown in the file below. Or, perhaps, you keep your address book on (gasp!) scraps of paper.

It's time to make good on that promise to yourself -- organize your contact list into a Microsoft Access database. It's much easier than you may imagine and you'll definitely be pleased with the results. This tutorial will walk you through the entire process step-by-step.

If you don't have your own spreadsheet and want to follow along with the tutorial, you can download the sample Excel file used to generate the tutorial.
  1. Prepare Your Data
  2. Create a New Access 2007 Database
  3. Begin the Excel Import Process
  4. Select the Source and Destination
  5. Select Column Headings
  6. Create Any Desired Indexes
  7. Select a Primary Key
  8. Name Your Table
  9. View Your Data

Previous | Next >>

 All Topics | Email Article | | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.