Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user12009546Apr 2 2012 — edited Apr 2 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2012

Added on Apr 2 2012

#general-database-discussions

1 comment

3,840 views