I have a million row, three column table with no indexes in a Jet .mdb
database on my local machine. Using ADO in Excel VBA code, using

SELECT MyKeyCol, MyDataCol, Col1
FROM MillionRowTable

it takes 5.1 seconds to get all rows into a recordset.


Jamie, are you connecting to an Access DB or SQL db? It only takes
5.1s to get 1M records into a recordset? Are u using this recordset
for a pivot table? (I'm kinda new to sql and using Excel like
this...I'm better with Access.)

Would you recommend using ADO in Excel VBA code to assign a pivot's
recordsource?