Show All

Create a query by using the Query Wizard

Some of the content in this topic may not be applicable to some languages.

1. Click New Query .
2. Select the Use the Query Wizard to create/edit queries check box.
3. On the Databases tab, double-click the database you want to retrieve the data from.

   If you need to set up a new data source, double-click New Data Source, and then specify the data source.

4. Follow the instructions in the Query Wizard.
5. In the Query Wizard – Finish dialog box, do one of the following:

   To return the data directly to Microsoft Excel, click Return data to Microsoft Excel, click Finish, and then select where you want to put the external data.

   To save the query in a .dqy query file that you can open and edit in Microsoft Query or open and run in Excel, click Save Query. This optional step is recommended if you plan to create an OLAP cube from the query.

   To run the OLAP Cube Wizard, where you can create a cube from the data in your query, click Create an OLAP cube from this query, click Finish, and then follow the directions in the wizard. This option is recommended only for experienced users. Learn about creating OLAP cubes.

   To refine the query further, click View data or edit query in Microsoft Query, and then click Finish. The result set is displayed in the Data pane, where you can make further changes and then return the result set to Microsoft Excel at a later time.

Tip To stop running a query that's taking a long time to retrieve data, press ESC.