Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 73

3 Click the Next button.

The last step in the Query Wizard is to choose where you want to send

the data. You can

1. Import the data into your Excel workbook.


2. Open the results of your query in Microsoft Query. Microsoft Query is a
   program included on your installation disk with several tools that allow
   you to create even more complex queries.
   You can learn more about these two options in Excel’s online Help. In this
   example, you’ll simply retrieve the data into your Excel workbook.

To fi nish retrieving the data:

1 Click the Return Data to Microsoft Excel option button.

2 Click the Finish button.

You can now specify where the data will be placed. The default will

be to place the data in the active cell of the current worksheet. In

this case, that is cell A1. Accept this default.

3 Click the OK button.

Excel connects to the Wheat database and retrieves the data shown

in Figure 2-29. Note that these include only those wheat products

whose price is $1.25 or greater and that the data are sorted in de-

scending order of calories. Also note that Excel has automatically

Figure 2-28
Sorting
records in
descending
order of
calories