Microsoft Access 2010 Bible

Chapter 17: Importing and Exporting Data

615

FIGURE 17.6

Excel worksheet columns should contain consistent data.

Data has been corrected

To import the Excel emplist.xls spreadsheet, follow these steps:

1. Click the Excel button in the Import group on the External Data tab.


2. Browse to the Excel file and click OK.


3. The first Import Spreadsheet Wizard screen (shown in Figure 17.7) shows lists of worksheets
   or named ranges in the Excel spreadsheet. Select a worksheet or named range and click Next.

FIGURE 17.7

The Import Spreadsheet Wizard

An Excel workbook may contain multiple worksheets and ranges