Querying Data Sources
Understanding Microsoft Query
In Excel, you can use a special program, called Microsoft Query, to create and run database queries. You can use Microsoft Query to create data sources, add tables to a query, specify fields, filter records using criteria, and sort records. You can also save your queries as query files so that you can reuse them later. If you start Microsoft Query from within Excel, you can return the query records to Excel and use them in a table or PivotTable.
All database queries require two things at the very beginning: access to a database and an Open Database Connectivity, or ODBC, data source for the database installed on your computer. ODBC is a database standard that enables ...