Thanks. And yes, the opening takes a bit of time, but I believe the problem is more that I'm getting the data one at a time. I've just remembered that I can grab the data using:

SomeVariant=ADODB_RecSet.GetRows

This pulls in the data all in one command, and seems to work real fast. The variant becomes a 2 dimentional array sized according to the amount of data you pull in.