select * from OpenRowSet('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;HDR=Yes;IMEX=1;Database=E:\附件一.xls', 'select * from [资产信息$]')
用上面的语句异常解决方案:
参考地址:http://hi.baidu.com/yiyishuitian/item/d2322435052aabfe96f88d9d
select * from OPENROWSET('Microsoft.Ace.OLEDB.15.0', 'Excel 12.0;DATABASE=D:\Project_ME\sankyo.xls' , 'Select * from [Sheet1$]')