Re: Microsoft Word and Oracle interface

You should install the SQLnet ODBC drivers for Oracle. Then create a database-link to your Server database. Create a table in you word document and choose for external data. Then MS-Query comes up and you can make your selection with MS-query. Form the FILE-menu you can send the output of your query to you MS-Word document. Of course this is usefull for ad-hoc queries. When you want to run this on a regular basis, create an Oracle Report and import this in your document. The same procedures for MS-Word works for MS-Excel.

Hope this will give you any idea.

regards,
Guus van de Sande
Indepent Oracle-consultant

Bob Johnson <send_at_no.junk.mail> schreef in artikel <6cghvt$3vo$1_at_info.curtin.edu.au>...
> 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
>
>
  Received on Mon Feb 23 1998 - 00:00:00 CST