在一个页面有2个Button1_Click事件。都要运行:
string sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + FileUpload1.PostedFile.FileName.ToString() + ";" + "Extended Properties=\"Excel 8.0;\"";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1);
但总是出错,怎么避免
string sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + FileUpload1.PostedFile.FileName.ToString() + ";" + "Extended Properties=\"Excel 8.0;\"";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1);
但总是出错,怎么避免
不是这个问题
2003和2007、2010的sConnectionString 是不一样的//office 2003
sConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source=" + frmI.strExcelName + ";" + "Extended ProPerties= \"Excel 8.0;HDR=Yes;\""; //office 2007和2010
sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + frmI.strExcelName + ";" + "Extended ProPerties= \"Excel 12.0;HDR=Yes;\"";