Display images in excel from SQL BLOB data

HI everyone,
I have a spreadsheet with a pivot table that pulls data out of a SQL database.
One of the fields is an image stored in a BLOB, is there a way I can display this image within Excel?

Thanks a lot

Have a look here, http://support.microsoft.com/en-us/kb/258038

BLOBs are just binary data, so you can either use the ADO stream object in the linked page or write as Binary. Once you've got the image then you can insert it into the workbook as you would any other image

No, you can use the vb native writer: http://www.vb6.us/tutorials/reading-...s-visual-basic

Though I'd use a stream as I find it cleaner

Will I need to save the image on disk or can I work with binary data?

I think you'll need to save the image on the disk, but I may be wrong