Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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...Received on Fri Dec 21 2001 - 02:56:19 CST
> 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
![]() |
![]() |