S
Simon Argent
I have made a connection to an AS/400 Database through Excel and have
successfully run a query against this and have pulled back the
required information.
I plan to run this query on a daily basis and the information is based
on date parameters that I enter. Currently the only way I know how to
do this is to edit the SQL 'Command Text' directly.
The command I currently have is
WHERE
(XMTFTXD45 between '20091021.000000' and '20091021.999999')
What I would like to do is to have the 2 dates entered into cells on
my Spreadsheet and for the SQL to query the cells directly.
Could anybody please help me with the syntax?
Much appreciated
successfully run a query against this and have pulled back the
required information.
I plan to run this query on a daily basis and the information is based
on date parameters that I enter. Currently the only way I know how to
do this is to edit the SQL 'Command Text' directly.
The command I currently have is
WHERE
(XMTFTXD45 between '20091021.000000' and '20091021.999999')
What I would like to do is to have the 2 dates entered into cells on
my Spreadsheet and for the SQL to query the cells directly.
Could anybody please help me with the syntax?
Much appreciated