Excel 2010 Bible

Part V: Analyzing Data with Excel

680

FIGURE 33.2

Use this dialog box to specify the location of the imported table.

FIGURE 33.3

An Access table, imported into Excel.

Retrieving Data with Query: An Example

This section discusses Microsoft Query, an application that ships with Excel. Use Query to import a

subset of a database.

Note
To perform queries using external databases, Microsoft Query must be installed on your system. If Query
isn’t installed, you’re prompted to install it when you first choose Data ➪ Get External Data ➪ From Other
Sources ➪ From Microsoft Query. n

The best way to become familiar with Microsoft Query is to walk through an example. In the

following sections, you learn how to use Query to open a database file and import a specified set

of records.