Consolidating OLE Object (Word Document) content

[Guest]

I have a table that contains an OLE Object type column. It is populated with
MS Word documents.

I need to be able to take the content of 1 record and append it to a
different record (consolidate the data from two records into one). I'm having
difficulty finding any reference material that suggests how to populate the
automation server with the contents of a field.

I've tried using the GetChunk / AppendChunk methods with DAO, but it doesn't
work properly (as it takes the entire value of the field in the record -
which is a complete Word document - and appends it to another Word document).

Any help is appreciated -

 

[Stephen Lebans]

Lookup Word Automation in the Access NG's. You would need to create two
instances of the Word object, select the contents of the first document
and copy them to the second Word document.

I bet if you searched on the MVP Word Web site you might find some code
to get you started. If not I would suggest you post in one of the MS
Public WOrd NG's. They are a very helpful group over there.
http://word.mvps.org/
--

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

 

[Guest]

Thanks Stephan - newsgroups, here I come!

Lookup Word Automation in the Access NG's. You would need to create two
instances of the Word object, select the contents of the first document
and copy them to the second Word document.

I bet if you searched on the MVP Word Web site you might find some code
to get you started. If not I would suggest you post in one of the MS
Public WOrd NG's. They are a very helpful group over there.
http://word.mvps.org/
--

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