Re: can Excel update Oracle tables directly?

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Mon, 3 Apr 2000 16:25:39 +0100
Message-ID: <8cagkn$b07$1@news8.svr.pol.co.uk>

Hi,

Of course it is possible to re-invent the wheel and make some vba code yourself. However, you may find yourself fixing all the problems I have encoutered while coding Oraxcel.

There are some formatting issues with Excel that are rather difficult to fix.

Oraxcel is not very expensive but the choice is yours...

Regards, Gerrit-Jan Linker

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in message news:8c9ht1$99l$1_at_soap.pipex.net...
> I haven't done this myself but it would be perfectly possible to write
some
> vba code that did this for you. In fact our software supplier has an xl
> add-in which updates its database directly from excel. the finance guys
love
> it as they don't need to leave excel. I hate it because I think it's just
> too risky.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "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 Mon Apr 03 2000 - 10:25:39 CDT