Thread: VBA lookup into large database
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gimme_this_gimme_that@yahoo.com is offline
external usenet poster
  
Posts: 129
Default VBA lookup into large database
I'd recommend filtering the data with where clauses in your SQL
statement.

Don't even use vlookup. Get only the data you need from the database.

Reply With QuoteReply With Quote