Import data from Excel in Asp.Net

There are various ways to import data from an Excel file to a Sql Server database table. We can use either a “DataSet” to import data into a table or by using the “SqlBulkCopy” class available in the namespace System.Data.SqlClient.

Continue reading...