This discussion is archived
0 Replies Latest reply: Mar 29, 2012 2:20 AM by user12009546 RSS

updating table record from excel to Oracle db table using ODBC connection

user12009546 Newbie
Currently Being Moderated
Hi,

We are currently undergoing testing in which we have to load data (tables/rows) from Oracle Database (10g/11g) onto Microsoft Excel 2007 and vice versa. We have currently established Oracle ODBC connection from Oracle Database to Excel 2007. As of now, we are able to successfully load data onto the excel sheet from database tables (we are able to load/fetch records) , but after updating/inserting rows in excel, we are unable to load the same onto the Oracle database.

Please suggest how we can insert/update data in Microsoft Excel 2007, and successfully load the same in Oracle Database table using the ODBC connection.


Thanks in advance,
Rahul

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points