Microsoft Office Tutorials and References
In Depth Information
Importing External Data
PivotChart to have the data in the Access data table imported into a
new pivot table (see Chapter 9) with an embedded pivot chart that you
can construct from the Access data
Only Create Connection to link to the data in the selected Access data
table without bringing its data into the Excel worksheet
Existing Worksheet (default) to have the data in the Access data table
imported into the current worksheet starting at the current cell address
listed in the text box below
New Worksheet to have the data in the Access data table imported into
a new sheet that’s added to the beginning of the workbook
Figure 11-10 shows you an Excel worksheet after importing the Invoices
data table from the sample Northwind Access database as a new data table
in Excel. After importing the data, you can then use the AutoFilter buttons
attached to the various fields to sort and filter the data (as described earlier
in this chapter).
Figure 11-10:
Worksheet
after
importing an
Access
data table.
Excel keeps a list of all the external data queries you make so that you can
reuse them to import updated data from another database or web page. To
reuse a query, click the Existing Connections button on the Data tab (Alt+AX)
to open the Existing Connections dialog box to access this list and then click
the name of the query to repeat.
Search JabSto ::




Custom Search