topic Images from blob Ms Access in QlikView

Images from blob Ms Access

Wed, 06 Jul 2011 16:05:21 GMT

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

Images from blob Ms Access

Wed, 06 Jul 2011 22:23:16 GMT

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.

Re: Images from blob Ms Access

Thu, 07 Jul 2011 09:04:52 GMT

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"

Images from blob Ms Access

brenner_martina — Thu, 07 Jul 2011 09:08:37 GMT

Hi,

you must use SQL Select:

BUNDLE Load ID,

Img_field;

SQL Select *

FROM DataTable;

Images from blob Ms Access

Thu, 07 Jul 2011 09:41:02 GMT

Thank you

It works fine