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

✦ From OData Data Feed to import data any database table following the Open Data Protocol (shortened to OData) — note that you must provide the file location (usually a URL address) and user ID and password to access the OData data feed before you can import any of its data into Excel.
✦ From XML Data Import to import data from an XML file that you open and map.
✦ From Data Connection Wizard to import data from a database table using the Data Connection Wizard that follows the OLEDB (Object Linked Embedded Database) standards.
✦ From Microsoft Query to import data from a database table using Microsoft Query that follows the ODBC (Open DataBase Connectivity) standards.
Retrieving external data with Microsoft Query
To retrieve data from an external database using Microsoft Query, you
must complete two procedures. In the first procedure, you define the data source — that is, the database that contains the data you want to query. In the second procedure, you specify the data query itself, including all the columns of data that you want extracted along with the criteria for selecting particular records.
Creating a new data source definition
To perform the first procedure that creates the new data source, follow these steps:
1. Click the From Other Sources command button on the Get External Data button’s drop-down menu on the Ribbon’s Data tab or press Alt+AFO and then select From Microsoft Query from the drop-down menu.
The Choose Data Source dialog box, shown in Figure 2-16, appears with the <New Data Source> item at the top of the list box on the Databases tab.
2. Click OK to accept the default <New Data Source> setting in the Choose Data Source dialog box.
This action opens the Create New Data Source dialog box where you need to name your new database query and specify the driver to be used in accessing the external database.
External Data Query 633
Book VI Chapter 2
Filtering and Querying a Data List