Hi,

I'm running a loop on 3 different SQL queries to pull data from a database using odbc connection. 

Please Login or Register  to view this content.
The code seems to work fine until the copyfromrecordset on the second and third queries. If I don't have the active X reference Capture.PNG then the data is missing the last few columns, if I do then it takes between 5 and 10 minutes to run.

Is there a better way to do this?

Many Thanks