急问将excel内容导入到数据库的一个问题
SELECT * into T
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="D:\我的工作区\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Test A$
~~~~~~~~~这里有错, 错误信息如下:
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'FUTURE'. The table either does not exist or the current user does not have permissions on that table.
请问该怎么解决? Test A必须分开写, 而不能合起来!