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,