Page 11 of 14PREVNEXT

Import data from Excel to a new table in Access 2007

Checking imported data

Verify the accuracy

As a final step, open your new table in Access and look at the data. Does it have errors? Is it all there? Do your dates and times use the correct format? Now is a good time to fix those kinds of issues. The practice session shows you how to fix a common problem, and links in the Quick Reference Card at the end of this course take you to information about issues not covered here.

Page 11 of 14PREVNEXT