Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Anyone using Datadirect ODBC on a mac with Excel to access an oracle database?

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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 21 Dec 2001 08:56:19 -0000
Message-ID: <3c22f935$0$8510$ed9e5944@reading.news.pipex.net>


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
Received on Fri Dec 21 2001 - 02:56:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US