Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

MS Query with Oracle as external data source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mandy - 20 Apr 2004 17:11 GMT
Our organization has recently discovered that it is possible to directly connect to the Oracle database from Microsoft Word (Word 2000 in our case) using the MS Query and ODBC drivers. This feature should allow our users to independantly obtain data from our Oracle database and merge fields into Word documents. We are excited about using this feature and would like to know which organizations are currently using this feature in the above mentioned manner and if so how successful have they been.
Peter Jamieson - 20 Apr 2004 19:32 GMT
I don't use Oracle for production work, but I spent some time a couple of
years ago looking at making Word mailmerge connections to Oracle databases.
One thing you may need to know is that the MS ODBC driver for Oracle is only
supported for connections to Oracle database version 6 (I think). However,
that does not mean that it does not work with later versions of the Oracle
database. I did not find it particularly difficult to connect to Oracle 8i
databases, but you may find that some data types (especially user-defined
types etc.) are not supported. If you don't use them, you will probably be
OK.

I also tried using Oracle's own ODBC driver and found that it was much
harder to use and much less reliable. But that may just be my experience.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Our organization has recently discovered that it is possible to directly connect to the Oracle database from Microsoft Word (Word 2000 in our case)
using the MS Query and ODBC drivers. This feature should allow our users to
independantly obtain data from our Oracle database and merge fields into
Word documents. We are excited about using this feature and would like to
know which organizations are currently using this feature in the above
mentioned manner and if so how successful have they been.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.