Re: Connecting MS Excel to Oracle Database
From: Ian C. Sellers <"Ian>
Date: 1997/08/12
Message-ID: <5sq17l$9f_at_news-1.boco.co.gov>#1/1
Date: 1997/08/12
Message-ID: <5sq17l$9f_at_news-1.boco.co.gov>#1/1
I have connected Excel 5.0 under windows 3.1 to oracle database using the odbc drivers that came with Excel. You use microsoft query (comes with Excel), which, AFAIK is used for just that purpose, pulling data into Excel from foreign sources. It's extremely easy to set up this way, but not fast! I just followed the manual's instructions.
-Ian
Nemani wrote:
> Is there any way we can connect MS Excel to Oracle Database for Query
> Purposes? As of today we are bringing data into Excel from Data
> Browser.
> This is two step process. I am just wondering if we can connect
> directly
> to DB using ODBC?
>
> Appreciate anybody's help.
>
> Thanks
> Rani
Received on Tue Aug 12 1997 - 00:00:00 CEST