How To Update A Table From Excel

[DeSorrow Golden]

How would I use a macro to update an Oracle table using Excel?

[Daniel Morgan]

DeSorrow Golden wrote:
How would I use a macro to update an Oracle table using Excel?

I would like people like you to stay as far away from Oracle databases
as is possible
without resorting to the use of physical restraints and violence.

Learn SQL*Plus. There is no justification for either willfull ignorance
or making a mess.

Hopefully your DBA will stop you cold.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Karsten Farrell]

DeSorrow Golden was kind enough to write: How would I use a macro to update an Oracle table using Excel?

You don't indicate your level of expertise, so I don't know how to
answer your question. Search Google for "oracle excel vba" (without
quotes) and click on a few of the zillions of links that look
interesting to you.

I hope you have considered the security ramifications and data
corruption possibilities of what you're proposing. Downloading to Excel
is one thing ... updating from Excel is quite another (and most likely a
bad -- terrible -- idea that will be frowned upon by your DBA).
--
[:%s/Karsten Farrell/Oracle DBA/g]

[Ryan Gaffuri]

"DeSorrow Golden" <desorrow_g@yahoo.com> wrote in message
news:b2785940.0306300841.572f9b12@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.