View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Schreiber Michael Schreiber is offline
external usenet poster
 
Posts: 3
Default Excel-SQL Connect

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