Microsoft Office Tutorials and References
In Depth Information
Start Microsoft Query
To create a query that defines the fields and
records that you want to work with in Excel,
you must begin by starting the Microsoft
Microsoft Query is part of the Office Tools
collection that ships with Microsoft Office. If
you like, you can start the program on its own
by pressing Windows Logo+R to open the Run
dialog box, typing the following path, and
then clicking OK:
However, you can almost always start it from
within Excel. That way, the data you configure
with the query is automatically returned to
Excel so that you can immediately begin
analyzing the data.
1 Click the Data tab.
2 Click Get External Data.
3 Click From Other
4 Click From Microsoft
The Choose Data Source
dialog box appears.
5 Click the data source you
want to work with.
6 Click to deselect the Use
the Query Wizard to
Create/Edit Queries check
7 Click OK.
The Microsoft Query
window and the Add
Tables dialog box appear.
Note: To learn how to use the Add
Tables dialog box, see the section,
“Add a Table to the Query.”