Page 109 - Excel Data Analysis

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

WORKING WITH EXTERNAL DATA 5

By default, when you import data from a When Excel imports a database table, the field
database table, Excel actually creates a database names appear in the first row of your worksheet.
query definition with the specified values. For If you do not want to import the field names,
example, if you import a table called Products you can deselect the Include field names option
from the Company database, Excel creates a ( changes to ) in the External Data Range
query file named Company Products.odc. Properties dialog box.
The query file contains information about the
database and your selected table. If you want to
import the same database table again, you can
simply select the query file.
You can set up a query file in the External Data
Ranges Properties dialog box. This dialog box
displays when you click the Properties button in
the Import Data dialog box. If you type a file
name in the Name field and click the Save query
definition option ( changes to ), Excel creates
the query file with your designated filename.

=$A$1

■ The Import Data dialog Á Type the cell reference for ■ The worksheet contains the
box displays. the first cell of imported data, contents of the imported
or select it with the Collapse database table.
ˇ Click the Existing Dialog button.
worksheet option to import
into the current worksheet. ■ To place the imported data
in a new worksheet, you can
click the New worksheet
option.
95
‡ Click OK.