Hi Tom,

you missed s't: OP said..
"I know you can do it with web queries."


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

You can import a textfile like any other "database" It would create
a querytable in Excel.

Instructions for xl2003 (introduced as a menu capability in xl2000)
On the Data menu, point to Import External Data and then click Import
Data to open the Select Data Source dialog box.
In the Select Data Source dialog box, in the Files of type list,
select Text Files.

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.

http://office.microsoft.com/training...ID=RP011801251
033&CTT=6&Origin=RC011801181033


To the OP.

You could look at the querytable objects on the sheets.