Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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