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 how to combine this power with Excel by showing you how to write a sheet to a delimited file and how to load a delimited file – using your own sql select statement – into an Excel sheet:
Zip archive containing example of Jet Text driver use through Excel / VBA
The function / routine for selecting records / executing an sql statement are kept minimal. In the rest of the example there is a great deal of VBA code to go through – including generic helper-routines, which might be of interest in themselves – so please let me know if anything needs to be elaborated.
I hope the Jet Text driver will prove as valuable to you as it has to me.