大家好,我在把DBF文件导入SQL 2005的时候出现了错误,请求高人指点。
代码:
select * into dbo.testing
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=e:\data\std_file','select * from EX130731.dbf')错误提示:
Ad hoc access to OLE DB provider 'MICROSOFT.JET.OLEDB.4.0' has been denied. You must access this provider through a linked server.
代码:
select * into dbo.testing
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=e:\data\std_file','select * from EX130731.dbf')错误提示:
Ad hoc access to OLE DB provider 'MICROSOFT.JET.OLEDB.4.0' has been denied. You must access this provider through a linked server.
EXEC sp_configure 'show advanced options', 1
GO
-- 重新配置
RECONFIGURE
GO
-- 启用xp_cmdshell
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
--重新配置
RECONFIGURE
GO
User does not have permission to perform this action.