Processing data from ODBC sources
You can process data from any ODBC source over the first row of a worksheet. You do not need to create a database alias for the source. The Process Data dialog includes a third type of source, ODBC, from which you can process data. You can also save previously defined ODBC and MS Query queries in a special format so they can be re-used as data sources. The ODBC processing function uses MS Query to define queries on relational sources. To be able to define queries for processing, you must have MS Query installed. This is not usually part of the standard Microsoft Excel installation.
You can use previously defined MS Query (*.DQY) or OLAP Server (*.ALQ) queries. Or you can define a new query.
To define a relational database query to process: