Hi,

I have one excel sheet with lakh records

Currently if i am trying to use this approach it was taking time

Currently my requirement is that after uploading of file insert records into particular table using stored procedure

Import data from Excel file to SQL Server in ASP.Net MVC

using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
     //Set the database table name.
     sqlBulkCopy.DestinationTableName = "dbo.Customers";
     //[OPTIONAL]: Map the Excel columns with that of the database table
     sqlBulkCopy.ColumnMappings.Add("Id", "CustomerId");
     sqlBulkCopy.ColumnMappings.Add("Name", "Name");
     sqlBulkCopy.ColumnMappings.Add("Country", "Country");
     con.Open();
     sqlBulkCopy.WriteToServer(dt);
     con.Close();
}

my self through stored procedure need to insert data into particular table

could you please help me