Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ricky Johnson   on Nov 13 In MS Office Category.

  
Question Answered By: Sam Anderson   on Nov 13

That's precisely my point!
My SQL select statements are returning 200,000 records in 10-12 seconds.
VBA processing of these records is what takes so long!
It's much more time-efficient to re-issue the select than it is to use
VBA to do the filtering!

Share: 

 

This Question has 19 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Populate Listbox Column Headings Or get search suggestion and latest updates.


Tagged: