Microsoft Office Tutorials and References
In Depth Information
l The Select Table dialog
box appears.
7
Click the table you
want to open.
8
Click OK.
l The Import Data dialog
box appears.
7
9
Click to select how you
want to view your data
(
8
changes to
).
9
Choose from Table, PivotTable Report,
or PivotChart and PivotTable Report.
0
!
0
Click to select where you want to put
your data ( changes to ).
Choose from Existing Worksheet or New
Worksheet.
@
!
Click the cell address or type a range if
you selected Existing Worksheet.
@
Click OK.
Your data appears in Excel.
Did You Know?
The Northwind database is a large database
elaborated over many years and distributed with
Access on the Office CD. The database includes
information about the products, customers,
employees, and other attributes of a fictional
gourmet food store. To follow along with this task
or to experiment with importing and querying a
database, you can install the Northwind database.
Did You Know?
You can apply the technique described in this task
to any database that has an ODBC (Open Database
Connectivity) driver, a standard interface. With
Excel, you can import databases such as Oracle or
Microsoft SQL Server, and desktop databases such
as Visual FoxPro.
Chapter 9: Extend Excel
207
 
Search JabSto ::




Custom Search