Hi ,

I've got an issue where I want to load date from MS Access to QlikView but there seems to be this error coming up.

Error : SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-01843: not a valid month

The date that i'm loading from MS-Access is this format .

The Query that I've Written on QlikView in order to get the data only for that particular day.

But the error i've been facing is not understandable to me as I'm new to QlikView.

Any sort of help is appreciated.

Thanks in advance.

Abhay.

use another provider?

OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=Z:\Spec.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False] ;

I wasn't sure until my Lead confirmed it to me.

Its from ORACLE To QLIKVIEW.

I tried the above but its not working out.

So what I did based on a small condition I pulled out some data from the ORACLE DB to have a look at the format of the "DATE_FIELD".

So this is the date field that I have in my ORACLE DB,

But i'm just not sure how do I pull it into QLIK.

The query which I tried but hasn't worked out.

Also , I'll correct the Discussion Topic.