Importing data from SQL database - Variables
 

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

Importing data from SQL database - Variables
 

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)

"daniB " wrote in message
...
Does anyone know if it is possible to import data from an SQL database
using a given variable.

I.e. the user inputs a date they wish to get the data from (i.e. from
1st Novemeber ). This date is then stored as a date variable. Using
this variable is it possible to import data from the database given
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 the
varibale 'dat'. (I am also unsure what the 'ts' bit means) If it is
possible what format does the date have to be in?

Stuck in a rut!!!!!
:confused:


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

Importing data from SQL database - Variables
 

Thanks Bob,

I think I understand now!

Dani:

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