Thread: SQL statement slower when refering to cells.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
  
Posts: 2,069
Default SQL statement slower when refering to cells.
I have a long sql statement that refers to cells to use as parameters. The
query takes about 20 secs to run if I refer to the cells. For example I'm
refering to cell [C3] for the YEAR parameter. If I hard code the year into
the sql statement it takes about 2 secs to run. Any ways around this?
TIA... John..
Reply With QuoteReply With Quote