Exporting images of type OLE-object RRS feed

  • 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

    Sunday, November 13, 2016 4:50 PM

All replies

  • Hi Peter,

    Have you seen this? OLE to Disk

    Either that or look up ADO Stream object.

    Hope it helps...

    • Proposed as answer by Chenchen Li Monday, November 14, 2016 5:25 AM
    Sunday, November 13, 2016 9:20 PM