Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 69

To see how this works, you’ll import another data set containing nutri-

tional data located in an Access database fi le named wheat.mdb. The database

contains two tables: Product, a table containing descriptive information about

each product (the name, manufacturer, serving size, price, and so on), and

Nutrition, a table of nutritional information (calories, proteins, etc.). You’ll

import the data by creating a connection to the database fi le using Microsoft

Query, a small application installed with most Offi ce 2007 products.

To access Microsoft Query:

1 Click the Office button and then click New to open a new blank

worksheet in Excel.

2 Click the From Other Sources button from the Get External Data

group on the Data tab and then click From Microsoft Query.

3 Verify that the Databases dialog sheet tab is selected.

At this point, you’ll choose a data source. Excel provides several

choices from such possible sources as Access, dBase, FoxPro, and

other Excel workbooks. You can also create your own customized

data source. In this case, you’ll use the Access data source because

this data comes from an Access database.

4 Click MS Access Database* from the list of data sources in the Data-

bases dialog sheet and click the OK button.

5 Navigate to the folder containing your Chapter02 data fi les and se-

lect the wheat.mdb database fi le. Click the OK button.

Excel opens the Query Wizard dialog box shown in Figure 2-25.

Figure 2-25
The Query
Wizard
dialog box

tables in the

Wheat database