Exporting OLE Objects

[MajP]

I have searched this site and have seen this question asked several times, unfortunately none of the posts are answered. I will try again anyway.
I have a table that is full of bloated OLE objects, mainly WORD, PDF, Power Point, and EXCEL. I want to export these to files and save in directories.
If you have code, I will galdly take it, but even a general strategy would help. Thanks.

 

[MajP]

I went here and modified the code.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;194975

Basically it uses the getChunck method
I am able to export the "files" and I get something. But when I open the Word Documents, I see what I gues is the binary data not the Word Document. It is like opening a Word document using a text editor like notepad. The header information looks correct I guess:
- ÿÿÿÿDocument Word.Document.8 Word.Document.8

So I am getting something. Anyone ideas suggestions?

 

[AlanJordan]

This is a work around, but it might help. Can you export to an rtf?

Later, if you want to reduce the size of the file, you can always automate the opening of the .rft and saving it as a .doc file.

Alan

 

[AlanJordan]

There is an example in the Access Help that uses the .GetChunk and .AppendChunk methods. Maybe that will help.