Page 10 of 13PREVNEXT

Import data: Import text files into Excel 2003

Import Data dialog box; External Data toolbar

Fig. 1  The Import Data dialog box is the last step to import the data when you use the Data menu to import text files.
Fig. 2  You can use the External Data toolbar to update data when you use the Data menu to import text files.

If you used the File menu method to import the file, click Finish, and you're done. The data from the text file is imported into Excel.

If you used the Data menu method to import the file, you click Finish and then there's an extra step: The Import Data dialog box appears, as shown in Figure 1, and you're asked whether you want to put the data in the existing worksheet or in a new worksheet. If you select New worksheet, Excel inserts a new worksheet in the workbook.

Refresh data

With the Data menu method, you can use the External Data toolbar to update the Excel data if the external data source is changed.

So, if you are keeping a weekly report of the sales orders for your salespeople, click the Refresh Data Button image button on the toolbar to get the latest data into the report and keep it current with the external data.

Page 10 of 13PREVNEXT