Microsoft Office Tutorials and References
In Depth Information
Running a query has benefits beyond opening a
database in Excel. For large databases, you can use
filters to restrict which rows and columns you view.
By saving the query, you can quickly return to the
queried data, refresh the data, and perform all
worksheet operations, such as applying functions,
using PivotTables, and creating charts.
Regardless of the data source, queries have a similar
format and you can reload them quickly. On the Data
tab, you can click Properties to review query properties
and change properties as needed.
Refreshing updates the data so you can see any
changes made to the data in Access since the last
refresh. To break your connection to the Access
database, click the Data tab and then click
Connections. The Workbook Connections dialog
box appears. Click the name of your query and then
You can import queries into existing or new
worksheets. After you import them, the worksheets
look like any other worksheet. Saving changes to the
workbook leaves the original query definition
untouched, so that you can reuse the query later.
Open your Excel worksheet.
Click the Data tab.
Click Existing Connections.
The Existing Connections dialog
Click the name of your saved