Exporting images of type OLE-object

Question

Hi

I have an MS Access database where a table contains images stored in an OLE-object column.

The images gets stored in the table from a form with a Bound OLE-control.
On the form the images are pasted to the control from the clipboard.

Now, I want to export these images to another system (SQL Server based) and are having some difficulties with this.

I have tried exporting the images to disk but these images are corrupted in some way.

Does anybody have any working tips of how to accomplish this task?

---

Best Regards Peter Karlström Midrange AB, Sweden

Answer 1

Hi Peter,

Have you seen this? OLE to Disk

Either that or look up ADO Stream object.

Hope it helps...