3
I have a report on Excel
where the data is displayed through a stored procedure
.
I have a problem because when I look for the value of the image field that is blob
, it displays binary code instead of image in the report.
How do I make for the Excel
read the query binary on stored procedure
and display the image?
The bank is SQL Server
.
https://support.office.com/en-us/article/Load-images-and-other-Binary-typed-data-into-the-Data-Model-23e61a1b-0ced-40b3-b1a2-1aed99d4d689
– mau humor
If you are not using powerpivot as @mauhumor quoted, please see these links: https://support.microsoft.com/en-us/kb/258038 - https://support.microsoft.com/en-us/kb/308042 - http://www.vb6.us/tutorials/reading-writing-binary-files-visual-basic you will definitely find your answer. I did not post as an answer, because at the moment I have no way to test... I hope to have helped.
– Evert