Please refer this one, https://www.c-sharpcorner.com/blogs/solution-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine

switch (extension { case ".xls" : //For Excel 97-03.conString = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString; break ; case ".xlsx" : //For Excel 07 and above. conString = ConfigurationManager.ConnectionStrings[ "Excel07ConString" ].ConnectionString; break ; } connExcel.Open(); I got error excel connetion open System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

Hi, Please use this one, Here you can remove code after Datatable fill then remove code to store in sql server database https://www.c-sharpcorner.com/article/export-and-import-excel-file/

Hi Jignesh kumar I want only upload excel sheet data into datatable (I'm Not using Sql Database)

Hi Narshima, Please find this link to achieve your task, https://www.c-sharpcorner.com/article/import-excel-file-to-sql-table-in-asp-net-mvc/

Answers

How to Excel Sheet data into Data table in Mvc5 use Ajax

Narasimha p

459

Answers (5)

Next Recommended Forum

How to merge MVC Web API into asp.net c# existing web site

I was working with Microservices but couldn't invoke methods

Forum Statistics

Please welcome our newest member Deepthi CJ.
3,095,450 users have contributed to 147,394 threads and 483,649
In the past 24 hours, we have 2 new threads, 6 new posts, and 81 new users.
In last week, the most popular thread is 'OOPS Concept'.

Upcoming Events

View all

The Cloud Show with Magnus Mårtensson ft. Mads Kempel Sørensen - Ep: 75
AI Agents Conference - 2025