O
Olaf Stetzer
Hello,
I am trying to set up an excel sheet which
queries data from several mysql tables (via myODBC).
In short, the first query results in two datetime
fields and some other information. Now I want to use
these two datetime fields as parameters in a second
query but this seems not to work. The second qery looks
like
SELECT something FROM tableXYZ WHERE datetimefield
BETWEEN [t_low] AND [t_high]
I edited this query with the MS-Query-editor. In excel
I assinged the correct cells (result from first query) to the
parameters t_low and t_high but I always get an empty result
from this. I have the feeling that the problem lies in the type
conversion between the excel cell and a datetime field for SQL.
If I try to edit the parameters in QUERY I get a box where one
chooses a datatype normally. I cannot change this from varchar
(greyed out, not changeable). I am really stuck here, can anyone
help me, please?
Thanks,
Olaf
I am trying to set up an excel sheet which
queries data from several mysql tables (via myODBC).
In short, the first query results in two datetime
fields and some other information. Now I want to use
these two datetime fields as parameters in a second
query but this seems not to work. The second qery looks
like
SELECT something FROM tableXYZ WHERE datetimefield
BETWEEN [t_low] AND [t_high]
I edited this query with the MS-Query-editor. In excel
I assinged the correct cells (result from first query) to the
parameters t_low and t_high but I always get an empty result
from this. I have the feeling that the problem lies in the type
conversion between the excel cell and a datetime field for SQL.
If I try to edit the parameters in QUERY I get a box where one
chooses a datatype normally. I cannot change this from varchar
(greyed out, not changeable). I am really stuck here, can anyone
help me, please?
Thanks,
Olaf