SQL variable exchange

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

Paul,
Check the Excel Help for "parameter_query".

NickHK

"Paul Shoemaker" <Paul [email protected]> wrote in message
news:[email protected]...
> 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