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

Faster CopyFromRecordset Please

P: n/a
Office97 / Access97 / Win2000
I'm using CopyFromRecordset to load four Excel sheets in the same
workbook with approx. 15,000 rows by 36 columns.
The process seems slow and I would like to know if there is a faster
method?

.Range("A2").CopyFromRecordset rsTotalPurchasedParts

Thanks for any help, Rick
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
rb*******@compuserve.com (Rick Brown) wrote in message news:<82**************************@posting.google. com>...
Office97 / Access97 / Win2000
I'm using CopyFromRecordset to load four Excel sheets in the same
workbook with approx. 15,000 rows by 36 columns.
The process seems slow and I would like to know if there is a faster
method?

.Range("A2").CopyFromRecordset rsTotalPurchasedParts

Thanks for any help, Rick


Did you do something like use GetTickCount or whatever to actually
time the thing? "Slow" is a relative term... mach 1 is slow if you're
used to going lightspeed, but what if you're a snail?
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.