Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Images from blob Ms Access

I have a Ms Access database with an OLE field that contains a bitmap picture

Is it possible to get this image and insert it into Qlikview report?

Thank you

1 Solution

Accepted Solutions
Not applicable
Author

You have an ODBC type connection to the database already correct? If so then it sounds like you should be able to use a statement like: bundle select image_field from table to get the image loaded into your qvw.

View solution in original post

4 Replies
Not applicable
Author

You have an ODBC type connection to the database already correct? If so then it sounds like you should be able to use a statement like: bundle select image_field from table to get the image loaded into your qvw.

Not applicable
Author

As you suggest, I have created a connection odbc to Ms Access db.

In the load script i wrote

BUNDLE SELECT Img_field FROM DataTable;

But this script return an error

"ODBC Read Failed

BUNDLE SELECT Img_field FROM DataTable"

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

you must use SQL Select:

BUNDLE Load ID,

      Img_field;

SQL Select *

FROM DataTable;

Not applicable
Author

Thank you

It works fine