Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle <--> Excel (Need Help !!)

Re: Oracle <--> Excel (Need Help !!)

From: <gjlinker_at_geocities.com>
Date: 1998/10/29
Message-ID: <71aro0$ev6$1@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US