Excel 2010 Bible

Chapter 33: Getting Data from External Database Files

687

For this example, select the Return Data to Microsoft Excel option button and then click Finish.

FIGURE 33.9

The final step of the Query Wizard.

Specifying a location for the data

Figure 33.10 shows the Import Data dialog box, which appears after you click the Finish button in

the Query Wizard.

For this example, select the Table option button and place the data beginning in cell A1 of the

existing worksheet. Click OK to import the data.

Note
If you choose PivotTable Report, or PivotChart and PivotTable Report, you can specify the layout for a pivot
table (see Chapters 34 and 35). In such a case, the database is used as the source for the pivot table, and the
original data table does not appear in your workbook. n

FIGURE 33.10

Specifying what to do with the data.

Figure 33.11 shows the data that is returned to a worksheet.