For More Power, Use Microsoft Query

If you want to go beyond the capabilities of the Query Wizard and employ complex queries and parameters to extract data from your database, use Microsoft Query.

Click Create New Query (Data menu). In the Choose Data Source dialog box, make sure that the Use the Query Wizard to create/edit queries check box is cleared.

Select your data source, and then click OK to display the Add Tables dialog box, in which you specify the database tables you want to use.

Drag to the lower part of the Query window each field that has data you want.

If you want to narrow even further the list of data returned to the worksheet, click Add Criteria (Criteria menu). Select a database field, operator, and target value, and then click Add for each criterion you want to add.

Click Return Data when you’re ready to return the data to your Microsoft Excel worksheet for further analysis.

For more information, click Microsoft Query Help (Help menu) while Microsoft Query is active.

Next Steps