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.
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.