Re: Access Oracle (Unix) from Excel (Pc)

From: Mark Richter <mrichter_at_oracle.uucp>
Date: Sun, 7 Nov 1993 21:58:43 GMT
Message-ID: <1993Nov7.215843.2349_at_oracle.us.oracle.com>


In article <2bdjtt$ps0_at_panix.com> rryan_at_panix.com (Rob Ryan) writes:
>In <tedh.752262269_at_tus.ssi1.com> tedh_at_delab4.tus.ssi1.com (Ed Henderson) writes:
>
>> We are using 2ndwind to access an Oracle Database on an HP server from
>>the PC. We use sqlnet for windows and FTP softwares PC/TCP for networking.
>> This scheme does not seem to be very robust. There HAS to be a better
>>way. I have read a few things about 1-2-3 and DataLens, but never used it.
>>Also, lots of people here (my boss included) like Excel (Or anything
>>Microsoft!!!). We are getting lots of complaints from users of the system
>>that we setup that it isn't as flexible as Excel! I just hate that. Oracle
>>isn't a spreadsheet, and a spreadsheet isn't a database. But they are the
>>users, and as such are always right.
>> I am looking forward to SqlForms 4.0, but it runs against Oracle 7.X and
>>we havent upgraded yet. We have the boxes, but no time!! Jeeeeezzz...
>>
>> Can any of you Oracle guys out there tell me what new capabilities Forms
>>4.0 brings to the table. I couldn't go to the Oracle Database forum..
>
>I know it's premature, but Excel v5.0 is being touted as providing integral
>ODBC support, so if you can wait a few months, that might be your solution.

Boo, hiss. ODBC .. horrible API, bad performance, least common denominator. From Excel to Oracle databases I recommend Oracle Glue. Ditto from VB.

  • mark
Mark D. Richter, Sr. Director Development                   1.415.506.4852
Oracle Corporation, Desktop Products Division       mrichter_at_us.oracle.com
500 Oracle Parkway, Box 659409, Redwood Shores, CA 94065 - CIS:70400,3514
------------ "Unlike leadership, golf builds character."------------------
Received on Sun Nov 07 1993 - 22:58:43 CET

Original text of this message