Good morning, I'm trying to read an Excel .xls file by the OLEDB driver used in SQL Server for integrations with Microsoft.ACE.OLEDB.12.0 files in SQL Server 2016 Express (64bit). Using the command OPENROWSET but I'm getting the famous error:
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null).
I have already performed several procedures reported in search but without success!
Procedures:
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
Selecting the worksheet:
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=C:\Users\Underline\Documents\Temp\Publicacao.xls', [Publicação $])
IhavealreadychangedthepermissionsonthefoldertoaccesstheNetworkandLocalaccounts:
I downloaded and installed the Microsoft Access Database Engine 2010 Redistributable x64 version, but nothing yet. Has anyone ever been in this situation? And please share some of your experience.