Page 113 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 99

WORKING WITH EXTERNAL DATA 5

In the Choose Columns page, you can view a If the database you are querying contains several
sample of the data contained in a particular tables, you can display the table names in
column. To do so, click the column and then alphabetical order to make it easier to locate. To
click the Preview Now button. A preview displays change the order of the tables, click the Options
in the Preview of data in selected column box. button in the Choose Columns page to display
You must perform the same steps for each the Table Options dialog box. Click the List
column you want to preview. Tables and Columns in alphabetical order option
( changes to ). If you do not select this
If you want to import an entire table from the option, Excel lists the tables in the order
database, you can do so by clicking the table specified by the database.
name and then clicking the Select button in step
10 of this section. When you do this, the names
of all columns in the table display in the
Columns in your query box. Excel adds the
column names in the order they appear in the
database.

12.9900
UnitPrice
Product Description

™ Type the comparison ■ You can further define ■ The Sort Order page of the ¢ Select a column by which
value in the field, or select your filter by clicking a join Query Wizard displays. you want to sort.
a value from the existing relationship and repeating
database column values. steps 13 and 14 for each
additional filter.
£ Click Next.

CONTINUED
99