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.
OpenXml is cross platform, so if you plan to create a .NET Core app, that should be your choice. You can't use either of the other libraries for creating Excel files, and Jet doesn't read xlsx files at all.
Member
4 Points
95 Posts
DocumentFormat.OpenXml Vs (Microsoft.Jet.OLEDB.4.0 & Microsoft.Ace.OLEDB.12.0) for Excel to Data...
Aug 24, 2020 03:30 PM|bsurendiran|LINK
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
All-Star
194428 Points
28074 Posts
Moderator
Re: DocumentFormat.OpenXml Vs (Microsoft.Jet.OLEDB.4.0 & Microsoft.Ace.OLEDB.12.0) for Excel to...
Aug 24, 2020 03:57 PM|Mikesdotnetting|LINK
OpenXml is cross platform, so if you plan to create a .NET Core app, that should be your choice. You can't use either of the other libraries for creating Excel files, and Jet doesn't read xlsx files at all.