Re: Connecting MS Excel to Oracle Database

From: Col Archibald <cad_at_qld.mim.com.au>
Date: 1997/08/15
Message-ID: <33F3DD05.2CB5_at_qld.mim.com.au>#1/1

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
M/S Query comes bundled with M/S Office Pro. It is generally seen as a ACCESS interface tool but can be installed with Excel to connect to ODBC to connect to Oracle. Look under 'data' menu item for 'get external data' or 'pivot table' to see if it's available. (Tip - make sure all products are either 16 bit or 32 bit - not both) Received on Fri Aug 15 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Thor-Ivar Skofsrud: "Problem with OWS 3.0 and SSL"
Previous message: Patrick Ryan: "Re: Reports 2.5 (Dev2K) and speed (is there any?)"
In reply to: Nemani: "Connecting MS Excel to Oracle Database"
In reply to Nemani: "Connecting MS Excel to Oracle Database"
Next in thread: Michael Friedman: "Re: How to increase the speed of Developer/2000 1.4 W when runing on appletviewer or any navigator?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message