string conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Employees.xls") + ";Extended Properties='Excel 8.0;HDR=yes;'"; //string conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath("Employees.xls") + ";Extended Properties ='Excel 8.0;HDR=NO;IMEX=1'"; //string conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Employees.xls") + ";Extended Properties=Excel 8.0"; OleDbConnection odcon = new OleDbConnection(conString); odcon.Open(); OleDbDataAdapter oda = new OleDbDataAdapter("select * from [Sheet1$]", odcon); DataSet ds = new DataSet(); oda.Fill(ds); odcon.Close(); GridView3.DataSource = ds; GridView3.DataBind();