Page 115 - Excel Data Analysis

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

WORKING WITH EXTERNAL DATA 5

You can save your database query definition so If you want to modify the database query, click the
that you can reuse it to perform the same query Edit Query button in the Import Data dialog box. In
again. You save a query by clicking the Save the Query Wizard that displays lists all of the
Query button in the Finish page of the Query current settings for the database query, and you can
Wizard. In the Save As dialog box, you can make any modifications in any page of the wizard.
specify a name and location for the query
definition file. All database query files have the If you want to keep any of the changes you make
extension .dqy. to the query definition, you must save it again by
clicking the Save Query button. You can either
You can run the saved query at any time by update the current definition file or create a new file.
clicking Data ➪ Import External Data ➪ Import
Data. In the Select Data Source dialog box that
opens, you locate the appropriate database
query file and click Open. In the Import Data
dialog box, specify the location for the data.

=$A$1

■ The Import Data dialog ■ To place the imported data ■ The worksheet imports the
box displays. in a new worksheet, click contents of the database
New worksheet. columns.
º Click Existing worksheet
to import into the current – Type the cell reference for
worksheet. the first cell of imported data.
≠ Click OK.
101