User1094269964 posted
Hi Friends,
We are having a requirement to upload excel data to Oracle Table using ASP.NET MVC application using oracle bulk upload.
The asp.net mvc application will list the list of tables from the oracle database. User will select table and click on download template.
When the user click on download template what we will do is "select * from <selectedTable> where 1 >1"
and we will construct DataTable in C# and the we will write excel file . User will download the excel and fill the data and upload the data using asp.net mvc application.
What we plan to do is read the excel file and convert that into Datatable in C# and we plan to do bulk upload to Oracle table.
To read the upload excel and convert that into Datatable which is the best choice in the below.
1) DocumentFormat.OpenXml
2)Microsoft.Jet.OLEDB.4.0
3)Microsoft.Ace.OLEDB.12.0
