1
good afternoon! I’m having trouble running an Openrowset:
use Planejamento_QA
go
select *
from openrowset('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0; Database=C:\Import_SQL\KE24.xlsx',
'KE24$');
go
Error:
OLE DB Provider "Microsoft.ACE.OLEDB.12. 0" for Linked server "(null)" returned message "Unspecified error".
Message 7303, Level 16, Status 1, Line 143 Cannot initialize the data source Object of OLE DB Provider "Microsoft.ACE.OLEDB.12. 0" for Linked server "(null)".
I’ve tried the following commands:
sp_configure 'show advanced options', 1;
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
exec master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
go
exec master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters',1
go
Does anyone have any idea what it might be?
Thank you!