void CXiaoshiDlg::OnButton1()
{
try
{m_pconnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XXX.xls;Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\"","","",adModeUnknown);
m_pconnection2->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XXX.mdb","","",adModeUnknown);
m_precordset->Open("select * from [XXX$]",_variant_t((IDispatch*)m_pconnection,true),adOpenDynamic,adLockOptimistic,adCmdText);
m_precordset2->Open(_variant_t("XXX"),m_pconnection2.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdTable);
m_precordset2->Close();
m_precordset->Close();
m_pconnection->Close();
m_pconnection2->Close();
}
catch(_com_error e)
{
AfxMessageBox("错误");
return;
}
}为什么运行错误呢?求指教
{
try
{m_pconnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XXX.xls;Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\"","","",adModeUnknown);
m_pconnection2->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XXX.mdb","","",adModeUnknown);
m_precordset->Open("select * from [XXX$]",_variant_t((IDispatch*)m_pconnection,true),adOpenDynamic,adLockOptimistic,adCmdText);
m_precordset2->Open(_variant_t("XXX"),m_pconnection2.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdTable);
m_precordset2->Close();
m_precordset->Close();
m_pconnection->Close();
m_pconnection2->Close();
}
catch(_com_error e)
{
AfxMessageBox("错误");
return;
}
}为什么运行错误呢?求指教
我要是排除了就不会来请教麻烦高手了