Possible to save contents of OLE Object fields back out into original doc's?
Posted on 2011-02-28
Hello - I have been re-working a database where the original developer saved Adobe pdf's, Word doc's and Excel spreadsheets into OLE Object fields.
Is it possible "reverse-embed" those items back out into individual files, in their original format?
At this point, I have:
1) the original table, which has a construction project ID # as the primary key, and OLE Object fields for Endorsement, Approval, Fund Release documents.
2) a revised table, which has the same primary key and document fields, but typed as Hyperlink's, instead of OLE Objects
My goal is to make one automated pass against the original table to save the document items back out as individual files, with enough parent key info in the file name to make another automated pass to link them back in to the new table with hyperlink fields.