Save OLEObject "value" from MS Access db as MS Word doc

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have an MS Access database in which one table has a "field" of type
OLEObject. That field contains MS Word docs, MS Excel workbooks, MS
Powerpoint presentations, Wordpad docs, etc.

I need to save each of these as individual files in specific folders.

I can use the GetValue(x) method to retrieve the object/file. I've tried
using FileOpen(i, path, OpenMode.Binary); FilePutObject(o); FileClose(i) but
the results are not "legal" documents, spreadsheets, presentations, etc.

How can I "get" the object/file and then save it as a file?

Thanks in advance!
Geoff

ps: using VB.net, but I can translate C# if need be :-)


.

Quantcast