Microsoft Office Tutorials and References
In Depth Information
Return the Query Results
Chapter 8: Querying Data Sources
The Import Data dialog
box appears.
3 Click to select the Table
option.
3
5
If you want to create a
PivotTable instead, you
can click to select the
PivotTable Report option.
4 Click to select the Existing
Worksheet option.
5 Click the cell where you
want the imported data
to appear.
4
6
If you want the data to
appear in a new sheet,
you can select New
Worksheet instead.
6 Click OK.
Excel imports the query
data into the worksheet.
Change It!
If you want to make changes to your
query, click any cell in the table (or
PivotTable), click the Design tab, click the
Refresh drop-down arrow, and then click
Connection Properties to open the
Connection Properties dialog box. Click
the Definition tab and then click the Edit
Query button. This starts Microsoft Query
and loads the query results. Make your
changes and then return the data to Excel.
More Options!
To save a query using Microsoft Query,
click File and then click Save to display
the Save As dialog box. Click the folder in
which you want to store the query file,
type a filename, and then click Save. To
use the query file, do the following: start
Microsoft Query, click File, click Open to
display the Open Query dialog box, click
the query file, and then click Open.
 
Search JabSto ::




Custom Search