Database Reference
In-Depth Information
Now let's import customer information from an Excel worksheet into a new table.
17
On the
External Data
tab, in the
Import & Link
group, click the
Excel
button to start
the
Get External Data
wizard.
18
Browse to the
Chapter10
practice file folder, click the
Customers
workbook, and then
click
Open
.
19
With
Import the source data into a new table in the current database
selected, click
OK
, which starts the
Import Spreadsheet
wizard.
10
Sample data from the selected worksheet or named range appears in a tabular format.
20
With
Show Worksheets
and
Customers
selected, click
Next
.
21
Select the
First Row Contains Column Headings
check box, and then click
Next
.