protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload2.HasFile)
{
string path = string.Concat((Server.MapPath("~/temp1/" + FileUpload2.FileName)));
FileUpload2.PostedFile.SaveAs(path);
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;");
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [school$]", OleDbcon);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(cmd);
OleDbcon.Open();
DbDataReader dr = cmd.ExecuteReader();
SqlBulkCopy bulkInsert = new SqlBulkCopy(con_str);
bulkInsert.DestinationTableName = "table";
bulkInsert.WriteToServer(dr);
OleDbcon.Close();
Array.ForEach(Directory.GetFiles((Server.MapPath("~/temp1/"))), File.Delete);
Label2.ForeColor = Color.Green;
Label2.Text = "successfully inserted ...
Go to the complete details ...