Re: Oracle access trough Excel

In article <1994Mar18.163055.1281_at_inet.d48.lilly.com> Paul Horan 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!usenet.ins.cwru.edu!lerc.nasa.gov!purdue!
> mozo.cc.purdue.edu!inet.d48.lilly.com!inet.d48.lilly.com!nntp
>Newsgroups: comp.databases.oracle
>Subject: Re: Oracle access trough Excel
>Message-ID: <1994Mar18.163055.1281_at_inet.d48.lilly.com>
>From: Paul Horan
>Date: 18 Mar 94 16:30:54 EST
>Distribution: World,world
>Organization: World
>Keywords: Oracle Excel Q&E Q+E
>Nntp-Posting-Host: kansasst.d51.lilly.com
>X-Newsreader: <WinQVT/Net v3.9>
>Lines: 27

>In article <1994Mar9.220724.21346_at_greenwich.com> pete_at_greenwich.com (Peter Sterne) writes:
>>I have been following this thread with considerable interest. Recent copies
>>of Excel have come with Q&E bundled in, and after looking over the documen-
>>tation I feel it would be very useful for a project in which I am involved.
>>
>>However, I am having trouble getting Q&E to talk with Oracle. For background,
>>I am running SQL*Net V2 on a 486/33 with 16Mb; the data base server is a SUN
>>Sparc 10 running SunOS 4.1.3. I have no trouble connecting the PC to the data
>>base when using Oracle SQL*Plus or Data Browser, just with Q&E.
>>
>>--
>>Peter Sterne, Sr. Programmer/Analyst
>>Greenwich Associates, Greenwich Connecticut
>>pete_at_greenwich.com, voice (203)625-5089, fax (203)629-1229
 

>Peter,
 

>The version of Q+E that is bundled with Excel 4.0 can only connect to Oracle6, not 7.
>To get to O7, you need the version of Q+E from the actual vendor, Pioneer software.
 

>Better yet, get a copy of ClearAccess, from ClearAccess Software, Fairfield, Iowa.
>This package integrates seamlessly with Excel's macro language, and makes data
>extraction into spreadsheets a breeze. Well worth the investment.

For yet another option you could upgrade to Excel 5.0 which includes MS-Query and can connect to Oracle7. MS-Query is based on the Access query engine and is ment to provide DBMS query capabilities for other Microsoft Desktop Apps as they are upgraded.

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