Hi Mike,

It is better use the standard SQL date format. For example,
select * from database
where date=TO_DATE(Format(Cdate("value from table1!
A1"),"DD-MMM-YYYY),"DD-MON-YYYY")

Best Regards

Bill


-----Original Message-----
Hi,

I have a little problem with my excel-SQL connection.

In one cell of my excel doc is a date. example 2003-11-04

I want to pass that date into my sql query.

select * from database where date="value from table1!A1"

is this possible?
I need a solution, so that the User in Excel can choose
the date and than
click run.

thx,
mike
.