SQL SERVER查询EXCEL数据出错
SQL SERVER查询EXCEL数据出错
用以下二种方法查询EXCEL数据,均出错
SELECT * FROM
OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="D:\Hand200902.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[200902$]
SELECT * FROM
OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source="D:\Hand200902.xls";User ID=Admin;
Password=;Extended properties=Excel 5.0')...[200902$]
出错信息
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table '200902$'. The table either does not exist or the current user does not have permissions on that table.
换另一台电脑就OK.
不知是什么原因?