string con = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("TowerWorkOrders20110316.xls") + ";Extended Properties=\"Excel 12.0\""; //string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("TowerWorkOrders20110317.xls") + ";Extended Properties=Excel 8.0"; OleDbConnection connection = new OleDbConnection(con); OleDbDataReader reader; connection.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$]", connection); reader = command.ExecuteReader(); ......... ........
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)