Re: Anyone using Datadirect ODBC on a mac with Excel to access an oracle database?

Yes it should be possible - though I'd use ADO/OLEDB. Can you post an example of the code.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Mark London" <mrl_at_psfc.mit.edu> wrote in message
news:20DEC01.15125190_at_psfc.mit.edu...


> I'm trying to use the datadirect connect odbc drivers to connect to an

oracle


> database (version 7.3.4) using SQL calls in Visual Basic in Excel.  Should

> this be possible?  I can connect and download data using Microsoft Query.

I


> can also successfully make a connection using SQLOpen in Excel, but a

query


> results in an error that says that this function is not supported.  Does

> Microsoft Query use SQL calls?  If so, why doesn't it work via Excel?

Thanks.


>

> Mark London

> MRL_at_PSFC.MIT.EDU