62,074
社区成员
发帖
与我相关
我的任务
分享
//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;\"";