Import Excel File in C#

In this code snippet you will learn how to import a excel file in c#.

string filename = "roc\\" + DateTime.Now.ToString("ddMMyyyyhhMM_") + FileUpload1.FileName;
   FileUpload1.SaveAs(Server.MapPath(filename));
   lblmsg.Text = filename;
string connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(filename) + ";Excel 12.0 Xml;HDR=YES"; // string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;" + // @"Data Source=" + Server.MapPath(filename) + ";" + //"Extended Properties=Excel 8.0;"; OleDbConnection con = new OleDbConnection(connectionstring); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", con); DataTable dtt = new DataTable(); da.Fill(dtt);