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

In article 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.
>
>-- Rob

Well, another possibility would be using Oracle's SQL-Browser for Windows and prepare a the most important SQL-scripts. Later you could use Excel to have a DDE-connection with the SQL-Browser to get the data and integrate it in your spreadsheet.

• Michael