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

the database and, if you had to specify a username and password to gain access to the database, you can have this information saved as part of the data source definition.
8. (Optional) Select the name of the default table from the Select a Default Table for Your Data Source (Optional) drop-down list box and select the Save My User ID and Password in the Data Source Definition check box to save this information.
Now you’re ready to close the Create New Data Source dialog box and return to the Choose Data Source dialog box from which you can per- form the second procedure of specifying your database query.
External Data Query 635
Figure 2-17:
Creating a new data source for the external database query.
9. Click the OK button in the Create New Data Source dialog box.
This action closes the Create New Data Source dialog box, returning you to the Choose Data Source dialog box, where the name that you’ve given to the data source definition that you’ve just completed appears selected.
Specifying the database query
Now that you’ve finished the data source definition, you can use it with
the Query Wizard to specify which fields in the database to acquire. At this point, the Choose Data Source dialog box is still open, and the name of your new data source definition is selected along with the Use the Query Wizard to Create/Edit Queries check box.
To perform the second procedure in which you specify the conditions of the query by using your new data source definition, follow these steps:
1. Make sure that the name of your data source is highlighted on the Databases tab and the Use the Query Wizard to Create/Edit Queries
Book VI Chapter 2
Filtering and Querying a Data List