Re: Word to Oracle via VBA

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3e928671$0$22004$ed9e5944_at_reading.news.pipex.net>...

> I don't think that that is quite correct Nuno. You need *either* an ODBC
> driver for Oracle (I'd choose Oracle's but it doesn't matter to get the
> thing operational) *or* Oracle Objects for OLE. These are alternative access
> technologies. There is a third technology OLEDB which in fact is the method
> I'd choose above either of the others

Isn't OLEDB the "successor" to OO4OLE? I thought it was. Just had a look at the setup in the office and it's Excel only with ODBC. Then it's got the Excel database query pack installed. This activates the "Get External Data" option in Data menu. And the "Run Database Query" option. There appears to be no need for anything other than ODBC, at least in Excel. I've got OO4OLE installed as well, but it's an old thing. I'd expect Word to also be able to work with only ODBC but as you say, it's better to use OLEDB. At least it simplifies the VBA code.

>
> code snippet follows (tested on word XP) demonstrating returning a recordset
> and using the oledb provider.

Thanks. Like I said, I use Exel97. I can't really provide detailed advice on later versions of Word. Your example looks very easy, I must try this out. Would come in very useful. Thanks a lot.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Tue Apr 08 2003 - 17:24:46 CDT