Re: Oracle <--> Excel (Need Help !!)
Date: 1998/10/29
Message-ID: <71aro0$ev6$1_at_nnrp1.dejanews.com>#1/1
Hi,
For this purpose I have developed a utility. It hooks up to Excel and shows as a new menu item called Oracle. You can evoke dialog boxes from here and issue SQL statements. Query results are fetched directly into your spreadsheet.
Please have a look at the site below. Screen prints and animated gifs of the working product are provided.
http://members.aol.com/gjlinker
http://members.aol.com/gjlinker/projects/oraxcel
Regards, Gerrit-Jan Linker
In article <01bdfaff$08df5360$202140ca_at_tiol_org.hk.super.net>,
"Cyrus" <cyruslai_at_yahoo.com> wrote:
> Anyone knows details about followings :
>
> Is it possible to ....
> o extract data from Oracle DB within Excel environment
> o make some modifications in Excel environment
> o update modified records in spreadsheet to tables in Oracle DB
>
> I have no idea. Urgent !! Need help
>
> Cyrus
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 29 1998 - 00:00:00 CET