Import data from Excel to a new table in Access 2007

Learn how to import data

Learn how to import data from Excel into a new table in Access. Importing is a simple way to put Access to work for you.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007 and Excel 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Prepare your data in Excel so that it imports successfully.

  • Import data from an Excel worksheet into a new table in Access.

  • Check your imported data for accuracy.

Before you begin

If you're new to Access, complete the course listed below before you take this course.

Topics in this course

  1. Import data

  2. The process has some limitations

  3. Prepare your data in Excel

  4. Start the import

  5. The import wizard: Step 1

  6. The import wizard: Step 2

  7. The import wizard: Step 3

  8. The import wizard: Step 4

  9. The import wizard: Step 5

  10. Check your imported data

  11. Practice

  12. Quick reference card

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!