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

510

1 .NET

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)