Update Oracle table with Excel

[tonbalits]

Hi guys,

I need help in creating a macro to update Oracle table using Excel worksheet or source of information where I can find some idea of how to do it. For Example:

A user entered 'CA' on cell A1(State column), the macro will open the Oracle Customer table and change the Salesrep field to "Joe Adams" for all rows that has "CA" on the state field and then commit the rows in oracle before closing the table.

Thank you for your assistance.

 

[zilpher]

Hi tonbalits

Welcome to the board

Search this board for Oracle or ADO, there are many examples of how to update databases from excel.

You'll need some particular SQL, something *like* this:

update customer set salesrep = "Joe Adams" where state = "CA"

commit will be a method of the ado object you create.