View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default SQL variable exchange

Paul,
Check the Excel Help for "parameter_query".

NickHK

"Paul Shoemaker" <Paul wrote in message
...
Hello,

I was wondering if it is possible for me take the datetimepicker date

value
and execute a SQL query based on that variable? I am using VSTO 2005 and
Excel 2003 and have a data source hooked up to a column (with an initial
query already specified), I need to pick the date from the datetimepicker
control and have it update the query so as to re execute the query based

on
the date (which, of course corresponds to an index table named

'row_date').

Thank you for your help.

Paul