How do you analysze data in a text file without importing
it into Excel. Does it have to be pulled directly into an
array in VBA? Or can you analyize the text file itself?

I have a text file. I want to:
1) Identify Number of Fields (i.e. columns)
2) Identify Number of records (i.e. rows)
3) Collect stats on the records by fields (Sum, Average,
Count etc)

However I do not know how to reference the fields and
records in a text file. And since I do not want to pull
this directly into Excel, I can't record the macro either.

Any help would be appreciated.

Thanks in advance.