E-Mail:

text driver

Microsoft Jet Text Driver and Excel

Using ADO and Jet Microsoft offers a way to view a folder, containing delimited text files, as a database where each file is a table.
The perspectives in this are great; you can perform joins, filtering, aggregation etc. without resorting to parsing techniques - you get to write sql queries instead!
In the example below I demonstrate [...]

23 queries / 0.133 seconds.