Skip to Main Content

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!

data from excel to oracle database

Green-bitMay 12 2015 — edited May 13 2015

Hello Guys, so here is the story.

I had a meeting with one of my development team, they said they needed a way to insert data into oracle table from excel data sheet. So I did a bit of googling and found out that sqldeveloper & toad have in built application that would facilitate the data transfer from excel data sheet into oracle table.

When I presented this solution to the development team, they rejected this idea saying this is not what they are looking for. Then they said, they need an application where in, as the data is being entered into the excel sheet, the data should simultaneously be entered into the oracle table.

they don't want to load the data into the oracle table once all the data is finished entered into the excel table, they want the data to be dynamically entered into an oracle table as the excel sheet is being populated.

Did you guys come across any such application or tool that does this? or any ideas on how to satisfy my developer's requirements is very very helpful.

Thank You

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2015
Added on May 12 2015
14 comments
1,210 views