Microsoft® Excel® 2010 Inside Out

Using Microsoft Query to Import Data

If you don’t have a connection already set up for the data you need, you can create one with the help of Microsoft Query, a versatile querying tool included with Microsoft Office 2010. Query generates statements in SQL and passes those statements to the data source while shielding you from the need to master SQL. If your query is relatively simple, you might not need to interact directly with Query; instead, you can formulate your request by means of a four-step wizard that acts as a front end to Query.

The first step in creating a query is to form a connection to the data source. Click the Data tab, click From Other Sources in the Get External Data group, and then click From Microsoft Query. The Choose Data ...