In article <6cghvt$3vo$1_at_info.curtin.edu.au>, Bob Johnson
<send_at_no.junk.mail> writes
>Hi,
>
>We would like to extract data from an Oracle database into a MS Word
>template document. Preferably the extraction should be selective (based
>upon options chosen from a macro).
>
>Has anybody done this recently and want to share approaches, problems or
>ideas.
>
>TIA
>Bob Johnson
>johnsonb_at_resources.curtin.edu.au
>
Although we use Forms 4.5 for most of our client-side stuff, for this
type of app we use VB as the client, with Oracle Objects for OLE to do
the database side, and OLE to control MS Word.
Works fine for us, but be careful to test separately for each version of
MS Word. We found that versions 6, 7(Word95) and 8(Word97) all behave
slightly differently as OLE servers, but that with care, we could
produce a generic VB executable.
We find this a much faster, more robust and more flexible solution than
using a combination of MS Query and ODBC.
Hope this helps.
--
Paul Brewer
Received on Sun Feb 22 1998 - 00:00:00 CST
