1. Home
  2. Computing & Technology
  3. Databases

Converting an Excel Spreadsheet to an Access 2007 Database

By , About.com Guide

1 of 9

Prepare Your Data

Sample Excel Database

Mike Chapple
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.
Explore Databases
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Tutorials
  6. Converting an Excel Spreadsheet to an Access 2007 Database>

©2009 About.com, a part of The New York Times Company.

All rights reserved.