If you follow the guidelines for data preparation, your import should be error free.
In Access, on the External Data Tab
, in the Import
group, click Excel
. That starts the Get External Data — Excel Spreadsheet
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.
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