Page 2 of 14PREVNEXT

Import data from Excel to a new table in Access 2007

The results of importing

Easier management, faster answers

Suppose you use Excel to store information about your company's computers. Over time, your worksheet has grown too big to manage easily — you have to scroll through too many columns and rows to find data, and that makes it hard to find answers. Importing that data into Access will make it easier to extract those answers because you can write queries, components that retrieve and process data quickly.

The import process follows these broad steps:

  • You start by cleaning up your data in Excel. For example, you remove any blank rows or columns, you make sure each column contains one type of data, such as dates or numbers, and you fix any errors such as #NUM or #DIV.
  • Next, you use the import wizard in Access to import the data to a new table.
  • Finally, you check your imported data for accuracy.

In case you're wondering, you can also import data into an existing table in Access, a process called appending. That isn't covered in this course, but links in the Quick Reference Card take you to information on how to do it.

Page 2 of 14PREVNEXT