Microsoft Office Tutorials and References
In Depth Information
Using Excel Data in Access
5. Click cell B1 , type HowOftenRequested , press the
key, type AvgHourlyFee , and then
press the Enter key. See Figure 2-10.
Excel worksheet prepared to be imported into Access
ori g inal rows
column heading added
6. Scroll down the worksheet to make sure there are no blank rows or other heading rows.
7. Save and close the workbook.
Importing an Excel List into an Access Table
Now you’re ready to import the Excel list into an Access table. To do this, you copy the
data from Excel to Access, maintaining two separate versions of the data.
Importing Excel Data into Access
Open the Access database where you want to import the Excel list.
Click File on the menu bar, point to Get External Data, and then click Import.
In the Import dialog box, click the Files of type list arrow, and then click Microsoft Excel.
If necessary, click the Look in list arrow to locate the Excel workbook you want to use,
and then double-click the workbook.
Follow the directions in the Access Import Spreadsheet Wizard.
You will import the Excel list to a new table in a new database.
To import the Excel list to a table in a new database:
1. Create a new, blank database in Access, name it Lifestyles Services , and save it in the
Tutorial.02\Tutorial folder included with your Data Files.
2. Click File on the menu bar, point to Get External Data , and then click Import . The Import
dialog box opens.
3. Click the Files of type list arrow, and then click Microsoft Excel .
4. Click Request List located in the Tutorial.02\Tutorial folder, and then click the Import but-
ton. The first dialog box of the Import Spreadsheet Wizard opens, as shown in Figure 2-11.