filename and path of linked ole file in blob field

[Rühmann, Günther]

hello,

I have an application with frontend Access 2000 and SQL Server 2000 als
backend.
One table contains a blob field that is filled with linked ole objects.

As I believe the filename and path of the file are stored in the blob field
instead of data .

Now, I need to push all these files from filesystem into a new blob field
with file data embedded.

Does anyone know a way how to move the files (paths must be in blob, but I
cannot access them) into a new blob programmatically ?

Best regards
Guenther

 

[Stephen Lebans]

Guenther have a look here:
http://www.lebans.com/oletodisk.htm
NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field. Version BETA 1.56

--

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

 

[Rühmann, Günther]

Hi I thank you very much for your respond. But it does not really help -
my English is not so perfect .....

What I mean is the reverse way. Not files themselves but links to the files
are stored in an OLE field. I´d like to loop though all records of that
table, get filename and path of the linked file and write that file -
embedded - into a new table. I found some code to write a file that way.
But I am looking for a way to extract filename and path to the linked files.

Regards
Guenther

 

[Stephen Lebans]

The Inventory function of my OLE extraction routines clearly shows the
linked path/filename(if any).

--

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