Insert Excel data to Database using C# and VB.Net in ASP.Net

Question

How to insert the excel document into the databaseAs I have 11 set of row in excel and around 400 rows are total rows how to separate 400 rows as 11 set or row and each row as separate column in databaseCan anyone give an idea

dharmendr · Accepted Answer

Hi SUJAYSYou can read the data from excel but it is difficult to identify the set of rows For this you need to write custom logic based on your excel dataForst read the excel data to DataTable There you will get one column in the Datatable Then loop through the DataTable rows and split the records to set of recordRefer below link to read the data to datatableImport Excel data to SQL Server Database in ASPNet using C and VBNet

Insert Excel data to Database using C# and VB.Net in ASP.Net

Import Excel data to SQL Server Database in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us