Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help on OLE object read from Access

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

8 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The zip file you uploaded seems to be corrupt.


talk is cheap, supply exceeds demand
Not applicable
Author

uploaded it again in the original post.

ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

Not working Ashfaq

Not applicable
Author

any luck

ashfaq_haseeb
Champion III
Champion III

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

Can you somehow provide me .mdb file.

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

Attached the mdb file.

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

Not applicable
Author

Experts pls help