Page 658 - Excel 2013 All-in-One For Dummies

640 External Data Query
The Import Data dialog box is also displayed when you click the Finish button when the Return Data to Microsoft Excel option button is selected in the Query Wizard — Finish dialog box, which is described in Step 9.
9. Click the Finish button in the Query Wizard — Finish dialog box.
This action closes this dialog box and opens the Import Data dialog box. Here, you indicate where you want to put the data acquired from the external database.
By default, the Table option is selected to import the data as a simple data list, the Existing Worksheet option button is selected, and cell A1 is designated as the start of this list’s range. To import the external data as a new pivot table (see Book VII, Chapter 2), click the PivotTable Report option button. To import the data as a new pivot table and pivot chart, click the PivotChart and PivotTable Report option button. To change the starting cell, click it in the worksheet. To import the data into a brand- new worksheet in the current workbook, select the New Worksheet option button instead. To add the data to the current Data Model in your Excel worksheet, select the Add This Data to the Data Model check box.
10. Indicate how you want to view the data and where you want the data imported during the query and then click OK to start importing the data.
As soon as you click OK, Excel executes the database query and acquires the data from the external database. (See Figure 2-22.) After the program finishes importing all the records that match your filtering criteria (when the Table option is selected), the program also displays the Table Tools contextual tab and selects its sole Design tab on the Ribbon. You can use the command buttons on the Design tab to further format the table (by selecting a new table style in the Quick Styles gallery), refresh the data by performing the query again (with the Refresh command button), or summarize the data list by creating a pivot table for it (with the Summarize with Pivot command button).
After you’ve saved the data query, you can use it to connect to an external database and to acquire its data according to the query’s parameters. To do this, click the Existing Connections command button on the Get External Data button’s drop-down menu on the Data tab of the Ribbon (or press Alt+AZXX) to open the Existing Connections dialog box and there click the descriptive name given to your query before you click the Open button.