Delete and Update from XL sheet to Oracle

Hello all,

I have one XL sheet Doc that has 2 tabs. One has the list of keywords for deleting the records from Oracle that has the keywords in it. The second one needs the update query. Read the first column in the XL sheet and replace it with the second column value for the records that has the first column value in it.

I never worked in the combination of XL and Oracle. Any help or Suggestions are really appreciated.

Jasmine.

I don't know if Oracle has anything in the vast enterprise tools in makes, but it seems like your going to need a third party language get involved in this.

Java or coldfusion can do it. I would recomend Coldfusion, its its learning curve is almost as flat as Nebraska. Yes, its a web development language, but i know it can do this.

[QUOTE=Ebot]
Java or coldfusion can do it. [QUOTE]

Thanks for your reply. I am comofrtable in Java rather than Cold fusion. Can you please give me the outline or any link for referring my requirement?

Jasmine.

hmmm, I've never had to do anything like this in java (I'm pretty new to the language) so i don't know how its done, but i do know it can be done.

Here is a site i found that should give you a starting point:

Linky