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.

Goals

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

Applies To: Access 2007, Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language