OraFAQ Forum: Windows » Data from Oracle to Microsoft Word

Home » Infrastructure » Windows » Data from Oracle to Microsoft Word (Oracle 9i, Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data from Oracle to Microsoft Word [message #513931]

Thu, 30 June 2011 05:38

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi All,
I need to create a doc file using Microsoft Word where I can get data from an Oracle DB.

I search on MS Word, for something like ODBC (like in Excel and Access) but in vain.

I need to do this so I can format the data on the doc file in any way I want. Not like in Oracle Reports, where formatting is a little bit restrictive.

Thank you in advance,

Amine

Report message to a moderator

Re: Data from Oracle to Microsoft Word [message #513932 is a reply to message #513931]

Thu, 30 June 2011 05:51

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

My first hit when I searched was this

Report message to a moderator

Re: Data from Oracle to Microsoft Word [message #513944 is a reply to message #513932]

Thu, 30 June 2011 06:47

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which has nothing to do with the question.

@Amine
You have to use VBA and ODBC/OO4O/OLE DB to access Oracle from Word document and generate it.
This is more a question to post in a Word or VB forum.

Regards
Michel

[Edit: correct wrong word]

[Updated on: Thu, 07 July 2011 13:42]

Report message to a moderator

Re: Data from Oracle to Microsoft Word [message #513949 is a reply to message #513944]

Thu, 30 June 2011 06:54

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

@Michel
Quote:

Which has nothing to do with the question

explain please

Report message to a moderator

Re: Data from Oracle to Microsoft Word [message #513951 is a reply to message #513949]

Thu, 30 June 2011 07:02

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The page explains how to store a word document into an Oracle database, the question is how to read Oracle data from a Word document to generate it.

Regards
Michel

Report message to a moderator

Re: Data from Oracle to Microsoft Word [message #513952 is a reply to message #513951]

Thu, 30 June 2011 07:06

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

ok..
Quote:

you can generate a word doc from Oracle table data you must install ...

Report message to a moderator

Re: Data from Oracle to Microsoft Word [message #513956 is a reply to message #513952]

Thu, 30 June 2011 07:09

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the example has nothing to do with the title.

In addition, the links are quite useless as they are quite difficult to deduce a practical example from them.

But what do you expect from this site?... you can ban it from your search.

Regards
Michel

[Updated on: Thu, 30 June 2011 07:11]

Report message to a moderator