Re: How to query ORACLE from EXCEL ? ? ? ? ?
Date: 1996/10/15
Message-ID: <NEWTNews.845386877.25869.dafis_at_ppp.test.jccbi.gov>#1/1
In article <1818619902.117319681_at_cornut.fr>, <fbouquet_at_cornut.fr> writes:
> Path:
news.ou.edu!news.ecn.uoknor.edu!munnari.OZ.AU!spool.mu.edu!howland.erols.net!ma
th.ohio-state.edu!jussieu.fr!univ-lyon1.fr!news.asi.fr!cornut!fbouquet
> From: fbouquet_at_cornut.fr (Frederic Bouquet)
> Reply-To: fbouquet_at_cornut.fr
> Newsgroups: comp.databases.oracle
> Distribution: world
> Subject: Re: How to query ORACLE from EXCEL ? ? ? ? ?
> Date: 15 Oct 1996 04:51:28 GMT
> Message-ID: <1818619902.117319681_at_cornut.fr>
> Organization: Cornut Informatique SA
> Lines: 12
>
> The answer to this question is easy:
>
> If your Oracle database is located on a Unis server, use CI-Link instead of
> SQL*net
> Try it by yourself (download it from www.cornut.fr)
>
> HTH
>
>
> --->> On our site a SHAREWARE SQL Query Tool <<-------
> Frederic BOUQUET Client/Server & SQL RDBMS
> email: fbouquet_at_cornut.fr http://www.cornut.fr/
>
We use EXCEL as our primary quiry tool. Actually, you use Micro Soft Quiry.
MS Quiry is an add on to EXCEL. If you have MS OFFICE or MS Professional???,
this is included on you install disks. You can use SQL*net and ODBC drivers.
You should have SQL*net and the ODBC drivers are free software you can down
load from www.oracle.com or from microsoft web site. Make sure your
TNSNAMES.ora is set up properly.(should have been created with network
manager). Once you can do an "ORACLE Net Test" (in c:\orawin\bin\nettest.exe)
and you have loaded the ODBC drivers. You will need to build a Data Source.
You can do this from excel. Once MS Quiry, TNSNAMES.ora, and ODBC drivers are
loaded, run excel...goto the menu bar...select "DATA"...goto "GET EXTERNAL".
This will start MS Query. Thier you can create a "New Data Source", just
follow the prompts. You cannot hurt anything so don't worry if you make a
mistake...just try again. The two parts of the data source that are critical
are you ORACLE7 (or ORACLE71) ODBC drivers, and you "Connect String". Make
sure you select the correct ODBC Driver (above) and use the correct connect
string loaced in your TNSNAMES.ora file.
Hope this helps
Martin Douglas Received on Tue Oct 15 1996 - 00:00:00 CEST