我用ADO将一张excel表导入到sql server中去,代码如下:
hr=m_pConnection->Open(_bstr_t("Provider=SQLOLEDB;server=TOUCH;Database=MR_NXT;Uid=touch0413;Pwd=LJm_1989915"),"","",adModeUnknown);
m_pConnection->Execute("select * INTO test FROM OPENROWSET('MICROSOFT.ACE.OLEDB.12.0' ,'Excel 12.0;HDR=YES;IMEX=1;DATABASE=F:\test.xlsx',[测试$])",&RecordsAffected,adCmdText);
_在执行Excute语句时,出现Idispatch error # 3092错误,但在sql server2008中执行同样的sql 语句又没有任何问题,我在网上看有人说是因为VC和数据库数据类型不一致的导致,请问怎么解决,求高手指导!!!