Page 108 - Excel Data Analysis

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

EXCEL DATA ANALYSIS

IMPORT A DATABASE TABLE

o prevent having to manually enter data for analysis database security. If you cannot do so, you may need to
from another program, you can copy data directly contact your Database Administrator.
T from an external database into Excel. Databases use You can only import one database table at a time into your
tables to store related values, similar to the format of an worksheet. If you want to import the entire database, you
Excel list. For example, a database table containing product must repeat the import process for each database table.
information may have columns for the Product Name, Price, When you select a table, Excel imports the contents of the
and Description. As you insert new records into a database entire table into the worksheet. If you want to import only
table, the program adds a value to each column of the table. records that match specific criteria, you must create a
In a product database, a record exists for each product. The database query. See the section "Using Queries to Screen
individual column values are fields in the database.
External Databases" for more information.
You can import database tables from any of the database Excel imports the table data into the worksheet by placing
formats supported by Excel, such as an Access database or each field in a separate column and each record on a
an ODBC database. To import a table, you locate the separate row. You can then use any of the formatting
corresponding database file in the Select Data Source options to format the data values. See Chapter 1 for more
dialog box.
information on formatting a worksheet.
To connect to a database table, you must have access to it.
In a corporate environment, this may require changes to

IMPORT A DATABASE TABLE

Ch05-Database.mdb

Products

⁄ In the Select Data Source Note: See the section "Import a ■ The Select Table dialog ‹ Click the desired database
dialog box, click the desired Delimited Text File" to access this box displays a list of the table.
database. dialog box. database tables.
› Click OK.
¤ Click Open. Note: The Select Table dialog box
does not display if there is only one
database table. Skip to step 5.

94