This can be done in fact I am also currently looking nto a similiar solution.
You can use the adodb object and open recordset by using TXT driver.On using
TXT driver you can select data  from file as if it was a table. Once you have the
data in record set you can put  it in EXCEL file ,I have got the code  from
internet but can put it up on 9 Jan.