4,011
社区成员
发帖
与我相关
我的任务
分享
CString ExlPathName = strFilePath + _T("\\demo.xls");//strFilePath是demo.xls的存放路径
CString strExcel = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + ExlPathName;
pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;"
"Data Source=demo.xls;"
"Extended Properties=Excel 8.0;",
"","",adModeUnknown);
CString m_strSQL= "Select * from [Sheet1$]";
pRst->Open(m_strSQL.AllocSysString(),
pConn.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText);