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

636 External Data Query
check box has a check mark in it and then click OK in the Choose Data Source dialog box.
This action closes the Choose Data Source dialog box and opens the Query Wizard — Choose Columns dialog box, similar to the one shown in Figure 2-18. This dialog box contains two list boxes: the Available Tables and Columns list box on the left side and the Columns in Your Query list box on the right side.
To select the fields that you want to acquire, click the Expand button (+) in front of the name of each table in the external database that contains fields that you want. Then, click the name of the field followed by the > button to copy the field name to the Columns in Your Query list box. To preview the data in that field, click the Preview Now button when the field name is selected in the Columns in Your Query list box.
Figure 2-18:
Specifying the fields to acquire in the new external database query.
Note that the order in which you add the fields determines their column order in your Excel worksheet. To change the order after copying the fields to the Columns in Your Query list box, click the field and then click the button to the right with the triangle pointing upward to pro- mote the field in the list, or click the button with the triangle pointing down to demote it in the list.
2. Select the fields that you want to use in the Available Tables and Columns list box on the left and then copy them to the Columns in Your Query list box on the right.
After you finish selecting the fields to use in the query, you’re ready to move on to the next dialog box in the Query Wizard where you specify how the data is to be filtered.
3. Click Next to open the Query Wizard — Filter Data dialog box.