You can get hold of MDAC 2.8 at

http://www.microsoft.com/downloads/d...displaylang=en

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cesw" wrote in message
...

Sean - Thanks for responding.

We decided to upgrade the users client to 9i, thinking that was why
they needed OraOLEDB.Oracle provider while those already on 9i were
using MSDAORA provider.

Unfortunately, the issue seems to also be related to the version of
Excel.
With 2000, MSDAORA works; it does not with Excel 2003.

Could this be related to different versions of MDAC?
The Excel 2003 users have 2.8 while the Excel 2000 users have 2.7
(I think - is there a way to verify this, or is it irrelevant?)

The OraOLEDB.Oracle provider does not work with 9i (it seems the OLE
and ODBC components are not part of the standard client
installation...)

Any suggestions are greatly appreciated.


--
cesw
------------------------------------------------------------------------
cesw's Profile:
http://www.excelforum.com/member.php...o&userid=27117
View this thread: http://www.excelforum.com/showthread...hreadid=473094