Document BLOB Export

[Guest]

Hi,

Wondering if anyone has ideas on how to effectively strip the OLE wrapper
from an Access BLOB field that contains a document (e.g. Word, Excel, PDF) as
it is exported or even just saving it to a file. Have seen stuff out there
on stripping the OLE header from an Access stored picture, but not stored
documents. Stored documents appear to have different and possibly variable
OLE wrapper. Target is a SQL Server Image field.

Any suggestion on technique and/or tools would be much appreciated.

Access 2003 DB, SQL Server 2000 target

 

[John Nurick]

Hi Greg,

The only way I know of doing this is to automate a BoundObjectFrame
control on a form so as to open the document in its parent application,
then automate the application to get the file. Very nasty, in fact.

If you go to groups.google.com and search for something like
access ole boundobjectframe form automate
you'll find a few posts (most of them by me, which is rather
depressing).

 

[Stephen Lebans]

John as soon as I get my ReportToPDF project stable I am going to tackle
this issue. I had to develop Structured Storage routines for my PDF library.
I will be able to build on this work to create an OLE object extractor for
all of the most common type of documents, Images etc. Structured Storage is
what was used to write the data to these OLE object fields and is therefore
what is used to read from these fields.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[John Nurick]

Great news, Stephen.

John as soon as I get my ReportToPDF project stable I am going to tackle
this issue. I had to develop Structured Storage routines for my PDF library.
I will be able to build on this work to create an OLE object extractor for
all of the most common type of documents, Images etc. Structured Storage is
what was used to write the data to these OLE object fields and is therefore
what is used to read from these fields.