Does anyone know if it is possible to import data from an SQL databas
using a given variable.

I.e. the user inputs a date they wish to get the data from (i.e. fro
1st Novemeber ). This date is then stored as a date variable. Usin
this variable is it possible to import data from the database give
this date scale?

for example:

Dim dat as date


(code for importing data using querytables.add)

.CommandText = ARRAY(SELECT table1.name, table1.address, table1.date
FROM databasey.table1 WHERE table1.date = ts '2003-11-01 00:00:01'})

Is it possible to replace the "ts '2003-11-01 00:00:01" with th
varibale 'dat'. (I am also unsure what the 'ts' bit means) If it i
possible what format does the date have to be in?

Stuck in a rut!!!!!
:confused

--
Message posted from http://www.ExcelForum.com