Hi

Lately I answered to similar question in NG microsoft.public.de.excel. The
thread was 'Excel in Verbindung mit Datenabnk benutzen', started by Wolfgang
Dausend at 30.10.2003 12:22. Maybe you get some ideas.


--
(When sending e-mail, use address )
Arvi Laanemets


"Michael Schreiber" wrote in 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