How to get date correct

[#1]

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.

[#2 · Accepted solution]

Hi Amelia,

Try this:

Load a,b,c

select SQL * from Table where Date>#09/01/2012#;

The # is delimiter for date in access.

[#3]

Thanks and that works perfect