Page 5 of 13PREVNEXT

Import data: Import text files into Excel 2003

Import Data commands on Data menu, and Select Data Source dialog box withText Files selected in Files of type list

Callout 1 On the Data menu, point to Import External Data and then click Import Data to open the Select Data Source dialog box.
Callout 2 In the Select Data Source dialog box, in the Files of type list, select Text Files.
Callout 3 Then, in the Look in list, navigate to the folder containing the file you want and select the text file you want to import. The file might be on your hard drive, a local network, or a disk.

Say that a list of salespeople with their order dates and order amounts is updated weekly in the source database. You'd want to create a report in Excel that you can update every week, to keep it current.

If there's any chance that you might eventually want to — or have to — update the imported data if the external data changes, you should import the external data by using the Data menu method:

On the Data menu, you point to Import External Data, and then click Import Data. Follow the rest of the steps to open the file as shown in the picture. After you click Open, the Text Import Wizard will open. You'll see next how to use the wizard.

Note     In this case, when you import a .csv file, it won't open directly in Excel as it does when you use the File menu, it will open the Text Import Wizard. This way, you can use the options in the wizard to make the data look tidy, if necessary, before you import it into Excel.

Page 5 of 13PREVNEXT