Page 101 - Excel Data Analysis

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

WORKING WITH EXTERNAL DATA 5

The Select Data Source dialog box lets what you select in the Files of type field.
you import data from several different The following table briefly describes
data types. Excel displays a different each of the file types that Excel can
wizard or dialog box depending upon import.

FILE TYPE DESCRIPTION
Office Database Connection Microsoft Office database connection files
Access Databases/Projects Microsoft Access files
Microsoft Data Links Contains OLE DB data source connection information
ODBC File DSNs Contains ODBC data source connection information
Web Pages Connection to Web pages to import tables
Text Files Text files exported from other sources
Lotus 1-2-3 Files Spreadsheet files from Lotus 1-2-3
Paradox Files Spreadsheet files from Paradox
DBase Files DBase database files
Web Queries Files for querying data directly from the Internet
OLAP Queries/Cube Files OLAP database query files
XML Files XML formatted data file

Ch05-CopyData.txt

› Click the desired text file. ˇ Click Open. Á Click the Delimited Note: Selecting the Fixed width
option. option results in a different Wizard.
■ Excel displays the Text
Import Wizard. ■ If the text has fixed widths ‡ Type the first row to
between fields, you can click import.
the Fixed width option.
° Click Next.
CONTINUED 87