Importing data

Hi Chris,

Thank you for your post and welcome to the forum: Try This:

Select Data, Get External Data, Import Text File. This command calls up a dialog box in which you select a text file, whereupon the Text Import Wizard lets you specify how Excel should import the data. Finally, in the Import Data dialog box, you indicate the desired worksheet destination. Excel imports the text file as a database query, which you can update if the data in the text file changes (select Data, Refresh Data to do so). To import the file as static data, click Properties in the Import Data dialog, and remove the check mark from the "Save query definition" box.

Hope that helped, regards Pete