Page 5 of 14PREVNEXT

Import data from Excel to a new table in Access 2007

Steps for starting an import

On your way with a few clicks

If you follow the guidelines for data preparation, your import should be error free.

Callout 1 In Access, on the External Data Tab, in the Import group, click Excel. That starts the Get External Data — Excel Spreadsheet dialog box.
Callout 2 Enter the location and name of your Excel workbook in the File name box. If you don't know the location, click Browse and use the File Open dialog box to locate your source data. If you're wondering, you'll select the worksheet that you want to import in a later step.
Callout 3 Make sure you select the first option, Import the source data into a new table in the current database, and click OK. That starts the Import Spreadsheet Wizard.
Page 5 of 14PREVNEXT