Re: Using Oracle DB in Excel

From: Rick Losey <>
Date: Tue, 18 May 1999 22:48:47 -0600
Message-ID: <5qr03.165$>

This has the same "flavor" as writing DAO code. However, it is much faster than ODBC based apps. There are two reasons for this, the first is that it communicates with the Oracle Call Interface (OCI) layer directly instead of going through ODBC to it, the second is that it is optimized for Oracle, whereas ODBC is not. Also note that Oracle only directly supports forward cursors in ODBC, however with oo4o, you get bidirectional capabilities. The [Quoted] downside is that you lose the flexibility to switch databases that ODBC gives.

Peter Hiemenz wrote in message ...
>In article <7hs14v$97u$>, Arjan van Bentem wrote:
>> You may also use Oracle Objects for OLE (oo4o) in your VBA code.
>Is this working well? I just removed using the ODBC driver supplied
>with the 8.0.3 client and replaced it with the current MS one.
>Peter Hiemenz
Received on Wed May 19 1999 - 06:48:47 CEST

Original text of this message