1、不要用双引号2、这样改写:
select * into a1yy from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=\\192.168.6.253\data\c.test',[sheet1$])3、要有远程共享目录的读权限
select * into a1yy from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=\\192.168.6.253\data\c.test',[sheet1$])3、要有远程共享目录的读权限
Server: Msg 7399, Level 16, State 1, Line 5
OLE DB provider 'MICROSOFT.JET.OLEDB.4.0' reported an error. The provider did not give any information about the error.
这是我写的代码。。
use dgztest select * into a2yy from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=\\192.168.6.253\data\c.test',sheet1$)