Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I am loading data from ODBC drive i,e from access database it is showing data type mismatch error
the query is
Load a,b,c
select SQL * from Table where Date>'09/01/2012';
Can anyone help me as I tried in many date formats but nothing works for me please help me as this is urgent now please.
Thanks.
Hi Amelia,
Try this:
Load a,b,c
select SQL * from Table where Date>#09/01/2012#;
The # is delimiter for date in access.
Hi Amelia,
Try this:
Load a,b,c
select SQL * from Table where Date>#09/01/2012#;
The # is delimiter for date in access.
Thanks and that works perfect