Dear all,
I need your help in writing a Macro to update a Oracle SQL database based on the values in an excel sheet.
Please assume the Oracle database details as below:
-------------------------------------------
Hostname : 1.2.3.4
Port : 1234
SID : DBUPDATE
Username : abc
Password : abc
--------------------------------------------
Table Name : employee_details
Table details:
emp_id, emp_name
1 -
2 -
---------------------------------------------
The content of excel sheet are as follows:
emp_id emp_name
1 a
2 b
----------------------------------------------
Could you please help with the VB Script to update emp_name in Oracle database based on entries in the excel sheet?
Thanks,
Vinod Krishna
Bookmarks