Export text files to excel

[Rattlesnake]

hi,
We have an application that produces tab seperated text files.It creates like 10 -15 files at one time. I want to create an application that will export SELECTED FIELDS from each text file (for. e.g. the 1st,5th,10th,20th values) to one excel sheet.(all 15 text files to one excel sheet)

The values should be APPENDED to the Excel sheet.
Basically it should be that the user selects the folder that contains the text files , and then all the files inside it are expoted to excel.

Any tips on how to go about this????
Thanks a lot.

 

[Fizzio]

Easiest way (I think) would be to import the text files to tables within Access, create a union query to amalgamate the results then export this result to the excel format.

Th only question is in this statement,

SELECTED FIELDS from each text file (for. e.g. the 1st,5th,10th,20th values

Do you mean fields or records as that will dictate how you extract the data. The former is easy, the latter not so.

 

[Rattlesnake]

I mean FIELDS. One text file is one RECORD. There many fields in it. So i just want to import the fields I want.

Thanks

 

[Daxton A.]

Well....

Since excel can open up text files and delimit tabs. Why couldnt you write a macro that opens the file and pulls data from the desired columns and apply the data where needed?