Re: Oracle access trough Excel

In article <2lb5r9$c87_at_Tandem.CAM.ORG> martin_at_CAM.ORG (Martin Carmichael) writes:
>Relay-Version: VMS News - V6.0-3 14/03/90 VAX/VMS V5.4; site edidev.dofasco.ca
>Path: edidev.dofasco.ca!mcshub!torn!howland.reston.ans.net!cs.utexas.edu!swrinde!ihnp4.ucsd.edu!
> pacbell.com!att-out!rutgers!utcsri!newsflash.concordia.ca!altitude!martin
>Newsgroups: comp.databases.oracle
>Subject: Oracle access trough Excel
>Message-ID: <2lb5r9$c87_at_Tandem.CAM.ORG>
>From: martin_at_CAM.ORG (Martin Carmichael)
>Date: 5 Mar 94 23:50:01 GMT
>Organization: Communications Accessibles Montreal, Quebec Canada
>Summary: Reaching Oracle database trough Microsoft Excel
>NNTP-Posting-Host: altitude.cam.org
>X-Newsreader: TIN [version 1.2 PL2]
>Lines: 14

>Hello.
 

>I have a couple end-users that need to access Oracle data trough
>MS-Windows spreadsheets like Excel or Lotus 123.
 

>Can somebody tell me wich way should I go? (How to do it?)
 

>The Oracle system 6.0 server is on a VAX/VMS 5.5 machine.
>The PC's can talk to them via DECnet. I believe SQL*net is a part
>of the puzzle.
 

>Is Microsoft ACCESS an alternative ?
 

>Thanks all.

You should be able to use Excel and Access against it. I am using Excel version 5, MS-Access, and several other tools like Forest & Trees against an Oracle 7 DBMS on an HP-UX machine.

You will need SQL*net (both on the server and the clients) to accomplish this even with the Microsoft ODBC drivers as they just sit on top of the SQL*net interface.

If you use Excel V5 or Access you
don't need anything beyond SQL*net and in your case DECnet. Excel V5 now includes a component product called MS-Query which is really the query engine from Access.

If you plan on using Excel V4 you can use the built-in Q+E interface to access Oracle as long as it is not Oracle V7. To use Excel V4 against Oracle V7 you need to upgrade the version of Q+E shipped with Excel to the full version of Pioneer's Q+E Database Editor V5. Oracle changed the names of the database catalog tables in V7 and broke 3rd party query tools. Since Microsoft was in the process of releasing Excel V5 with the Access query engine instead of Pioneer's Q+E product they never upgraded teh builtin version of Q+E to support Oracle V7.

Hope this helps more than it confuses.

john

John Novak                                Dofasco Inc.
Specialist - Computing Technology         1330 Burlington St. East
IS - Applications Development             Hamilton, Ontario, CANADA L8N 3J5
                                          phone: (905)544-3761 ext 2769
Usenet:     john_novak_at_dofasco.ca         fax:   (905)548-4292

Disclamer: The views represented are my own and do not reflect those of my

            employer in any way!

Answer to all questions: 4T2