Page 7 of 14PREVNEXT

Import data from Excel to a new table in Access 2007

The import wizard, screen 2

Always use column headings

On the second screen, make sure the First Row Contains Column Headings check box is selected and click Next.

Column headings make your database much easier to use.

Page 7 of 14PREVNEXT