"Loane Sharp" wrote ...

The real pain is that it took 38 hours to pull the data into Excel
record-by-record

I don't understand why you are reading the data to Excel row by row.

It seems that
the "hog" is the [Recordset].Open method, which must be given
for each of the 107288 records.

Opening a recordset for each of your 100K rows definitely sounds
wrong.

I think you should aim to use sql to get one recordset of all the rows
you need in Excel. What are you doing in your For (i = 1 to
107288)...Next loop that you can't do in sql?

Jamie.

--