Importing data from SQL database - Variables

  • Thread starter Thread starter daniB
  • Start date Start date
D

daniB

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
 
Dani,

It should be straightforward to replace the date with a variable. Only thing
to watch is that the SQL statement expects strings, so the date should be
formatted as a string, like this

CommandText ="SELECT table1.name, table1.address, table1.date FROM
databasey.table1 WHERE table1.date >= """ & Format(myDate,"dd-mmm-yyyy") &
"""

Can't hrelp you withthe ts I am afraid.
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top