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

Faster way to copy a recordset in VBA

P: 1
Hi,
I am trying to copy around 300 records from access to excel using sql. In my sql query, I am joining 2 tables and then copying the data from access.
I checked the run times and it seems that copy recordset function is taking a lot of time. Is there any way to increase the speed and optimize the code? I am also using
rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly (explicitly coping the records. Please suggest me a way.
Jul 2 '13 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,370
We would need to see your code. It's hard for us to optimize code that we can't see. Please remember to use code tags when posting code per the forum FAQ.
Jul 2 '13 #2

Post your reply

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