Images from blob Ms Access

[#1]

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

[#2 · Accepted solution]

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.

[#3]

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]

Hi,

you must use SQL Select:

BUNDLE Load ID,

      Img_field;

SQL Select *

FROM DataTable;

[#5]

Thank you

It works fine