How to Import Excel data to oracle database using ASP.NET ?

Question

I want to import excel data in Oracle database. How to Import Excel data to oracle database using ASP.NET ?

Sanket Jain · Answer

How to use interop to read the excel data ? SQLBulk operation is in the directory but how to use oraclebulk operations? Which Directory I use for oraclebulk operations?

Alice Smith · Answer

One simple way is to use interop to read the excel data and then ODP.NET bulk operations to insert the data into the database.

Chandu Kumawat · Answer

http://www.advancesharp.com/questions/18604/import-data-from-excel-to-oracle-database-table-in-asp-net-c-sharp https://social.msdn.microsoft.com/Forums/office/en-US/d8aee782-8e93-4760-92b1-e6988bd7aacb/how-to-insert-excel-sheet-data-into-the-oracle-server-using-aspnet-application?forum=officegeneral http://www.experts-exchange.com/questions/28533557/Imort-Excel-data-to-oracle-database-using-ASP-NEt-C.html