Access Document BLOB Export

[Grandgousier]

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.

 

[Bob Buckland ?:-\)]

Hi Greg,

You may want to also post this in the MS Access group (link below) and include the version of Access you're working with and if
you're working from within Office or from outside.

=====
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.


--
Greg Hayes>>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com