Microsoft Office Tutorials and References
In Depth Information
Importing Data from an Excel Worksheet
To import the Invoices worksheet into the Invoice table:
1. Click the Close ‘Invoice’ button on the object tab to close the Invoice table. A
dialog box opens asking if you want to save the changes to the table layout. This
dialog box opens because you resized the table columns.
2. Click the Yes button in the dialog box.
3. Click the External Data tab on the Ribbon.
4. In the Import & Link group on the External Data tab, click the Excel button. The
Get External Data - Excel Spreadsheet dialog box opens. See Figure 2-23.
Get External Data - Excel Spreadsheet dialog box
click to find the Excel
workbook contai ning the
data you want to import
you might see a
different path here
option for adding
records to an
The dialog box provides options for importing the entire worksheet as a new table
in the current database, adding the data from the worksheet to an existing table,
or linking the data in the worksheet to the table. You need to add, or append, the
worksheet data to the Invoice table.
5. Click the Browse button. The File Open dialog box opens. The Excel workbook file
is named “Invoices” and is located in the Access1\Tutorial folder provided with
your Data Files.
6. Navigate to the Access1\Tutorial folder, where your starting Data Files are
stored, and then double-click the Invoices Excel file. You return to the dialog box.
7. Click the Append a copy of the records to the table option button. The box
to the right of this option becomes active. Next, you need to select the table to
which you want to add the data.
8. Click the arrow on the box, and then click Invoice .
9. Click the OK button. The first Import Spreadsheet Wizard dialog box opens. See