Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle <--> Excel (Need Help !!)
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 CST