topic Re: Need help on OLE object read from Access in QlikView

Need help on OLE object read from Access

Wed, 11 Jun 2014 12:03:13 GMT

Tried info, bundle loads but not able to view the images

Re: Need help on OLE object read from Access

Gysbert_Wassenaar — Wed, 11 Jun 2014 12:14:00 GMT

The zip file you uploaded seems to be corrupt.

Re: Need help on OLE object read from Access

Wed, 11 Jun 2014 12:47:40 GMT

uploaded it again in the original post.

Re: Need help on OLE object read from Access

ashfaq_haseeb — Wed, 11 Jun 2014 13:07:26 GMT

Hi try below in load script

ODBC CONNECT TO [testatt;DBQ=D:\mdb\test.accdb];

// info

// LOAD ID,

// png;

//SQL SELECT *

//FROM Table1;

//OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=dise;Data Source="";Extended Properties=""] (XPassword is MFUFBSFNTLZGD);

bundle iNFO SELECT ID, Attachment FROM Table1;

//OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=qed;Data Source=qedquest-PC;Extended Properties=""] (XPassword is ffACfYVMELLA);

//bundle info

//SELECT *

//FROM DISE.TEST;

Regards

ASHFAQ

Re: Need help on OLE object read from Access

Thu, 12 Jun 2014 06:06:37 GMT

Not working Ashfaq

Re: Need help on OLE object read from Access

Thu, 12 Jun 2014 09:00:16 GMT

any luck

Re: Need help on OLE object read from Access

ashfaq_haseeb — Thu, 12 Jun 2014 09:08:07 GMT

Hi the proble is that I cannot read your .accdb file

Can you somehow provide me .mdb file.

Regards

ASHFAQ

Re: Re: Need help on OLE object read from Access

Thu, 12 Jun 2014 09:31:18 GMT

Hi Ashfaq,

Attached the mdb file.

Also as a alternate you can use the driver for accdb(ms office 2007)

Re: Need help on OLE object read from Access

Mon, 16 Jun 2014 06:33:19 GMT

Experts pls help