Display image in Excel using binary code

Asked

Viewed 62 times

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

  • 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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.