Re: How To Update A Table From Excel
From: Ryan <rgaffuri_at_cox.net>
Date: Tue, 01 Jul 2003 00:45:24 GMT
Message-ID: <EQ4Ma.38486$pH3.16983_at_news2.east.cox.net>
Date: Tue, 01 Jul 2003 00:45:24 GMT
Message-ID: <EQ4Ma.38486$pH3.16983_at_news2.east.cox.net>
"DeSorrow Golden" <desorrow_g_at_yahoo.com> wrote in message
news:b2785940.0306300841.572f9b12_at_posting.google.com...
> How would I use a macro to update an Oracle table using Excel?
asktom.oracle.com
He gives a few methods... all of which require quite a bit of technical work to learn how to do it .I dont think they require much code. A simple macro alone wont be enough. You will need to connect to the ODBC.
a side note. you can also embed Excel into forms by using the OLE handlers. I havent looked at the 9i Forms demo, but there is a sample form and library in the 6i demo. So I would 'assume' its in the 9i one. Received on Tue Jul 01 2003 - 02:45:24 CEST