How are the files delimited?
How many columns, and which columns should be averaged/imported?

You *could* try using the ADO text driver and running some SQL to summarize the data. That might work (depending on the format).
If you want to send some sample data you can contact me directly at <tim j williams at g mail dot com (no spaces and make the
obvious replacements...)

--
Tim Williams
Palo Alto, CA


wrote in message oups.com...
Hi,
I have to extract 300+ text files (they are symmetric, same number of
columns) into an excel spreadsheet. Each file contains about 1800
lines. Will Excel support that many lines? What method do i use to
extract them. I don't want to open each file and do a copy all, then
paste into Excel. Please Help! Thanks