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

405

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

Leaderboard

View all

Rodrigo Diaz

Magnus Mårtensson

Tuhin Paul

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

186

13k

10.5k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

288.8k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.3k

58.5k

Upcoming events

View all

Suggested for you

View all

Pushpendra Shukla

Afsar Uddin

Balaji Thilagar

Arjun Karthikeyan S

Yogi S

Forum Statistics

Please welcome our newest member Amapola karlen.
3,077,165 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 5 new threads, 19 new posts, and 169 new users.
In last week, the most popular thread is 'Object reference not set to an instance of the Object.'.