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.
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 on the toolbar to get the latest data into the report and keep it current with the external data.