O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Using a Query to Retrieve External Data

Choosing File, Open is fine for bringing an entire external data file into Excel. When the information you require resides in a server database, such as SQL Server or Oracle, or when you need to fetch particular records from a large data repository, you need a query.

When you retrieve data by means of a query, you can limit the import to records that meet particular criteria. Moreover, the incoming data becomes a "data range" on the current worksheet, allowing you to refresh the query periodically or when the need arises.

Database queries in Excel are in most cases accomplished through the intermediation of Microsoft Query, a querying tool supplied with Microsoft Office. Query generates statements in the SQL ...

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