I have an app that unzips files from a CD, parses the resulting text
files into virtual recordsets and recordsets attached to Access97
tables, then does some slicing and dicing and then mixing and matching
of the data.  The records number into the millions.  I'm using an ADO
connection and recordsets as well as ODBC.  The code works perfectly
through all the steps.  The problem is, it runs incredibly slow.  Any
suggestions for optimization would be greatly appreciated.  I'm
currently looking at Disconnected Recordsets, and incorporating ADO
Command objects for executing repetitive action queries.  Any comments
on the efficiency of these techniques?  Thanks in advance.
cb