By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

VBA query a recorset or a table from memory????

P: 93
Hi

I have a large table and I need to submit 500 queries (each one is different)

I don't want to use recordset.open strSQL as it taking to much time (it should be below 0.15s and the table is 200 000 records)

So what I'm thinking is to have a table in memory?? so I can submit SELECT query on it. Is that possible??

something like SELECT field1 FROM recordset? or table in memory?

Many thanks in advance.
Emil
Aug 11 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.