Re: Word to Oracle via VBA

"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message news:Xns9358C7B7D1824Tokenthis_at_210.49.20.254...
> Following up on Niall Litchfield, 09 Apr 2003:
>
> > Its the fact that OLEDB is the later, faster (and still being updated)
> > technology which is why I would generally use it. Word will use ODBC,
the
> > only thing that would require changing in my code would be the
connection
> > string. Connection string formats can be found at
www.connectionstrings.com
> >
>
> Thanks, chief.
> I just reviewed my Word2K VBA book. Apparently, OLEDB
> can actually use an ODBC driver, besides the specific OLEDB
> ones provided by Oracle or whoever. Have you tried this
> at all?

In a word No.

> Interesting stuff. One wonders: why use specific report
> writer tools when the best possible report writer is already
> operational in one's PC and ready to go to the nearest db?
> ;)

I guess because report writer tools mean that the report writer doesn't have to do any programming. (yeah right). My impression is actually that many organisations have the Office suite installed on every PC but never think to automate it to streamline business processes. It might be that the task is tried and found wanting, but my impression is it is found difficult and not tried.

--
Niall Litchfield
Oracle DBA
Audit Commission UK