Re: can Excel update Oracle tables directly?

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Sun, 2 Apr 2000 20:54:09 +0100
Message-ID: <8c9i5g$s4$2@news6.svr.pol.co.uk>

Oh yes we have! --- Oraxcel ---- is what you need.

http://www.oraxcel.com

Oraxcel allows you to fetch the data you want to change directly into an Excel sheet. You simply change the values you want and click update. Voila!

If you need more raw power. It can take update statements as well. You can also send a whole range of update statements in a anonymous pl/sql block. That'll look something like this:

    begin

        update mytable set mycolumn = myvalue1 where a=b;
        update mytable set mycolumn = myvalue2 where c=d;
        update mytable set mycolumn = myvalue3 where :C1=:D2;

    end;

And yes, you can use the contents of other Excel cells in this process. Either through using the Excel concatenate function: =concatenate("update a set col=",A1)
or through bind variables like in the last example above.

Anyways, have a look at Oraxcel at http://www.oraxcel.com There is demo material on the site and you can download the free LITE version.

Greetings, Gerrit-Jan Linker

Susie Grace <hlng_at_usa.net> wrote in message news:8c7t7f$g12$1_at_nnrp1.deja.com...
> Has anyone updated an Oracle table based on the values of select Excel
> cells directly (without writing / exporting to a flat file first)?
>
> Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Apr 02 2000 - 14:54:09 CDT