O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15

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.

Data Source

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required