How to correctly write ConnectionString for OpenRowSet (excel source)?

Question

SQL Server

There is a data source in Excel, from which you will need to periodically pull the information to the server. I wanted to make a linked server, but I didn't find Microsoft.Jet.OLEDB.4.0 in the
Provaiders list
Excel 2010 32-bit
Sql server 64- bit Excel 12.0;Database=d:\test\1.xlsx', 'SELECT * FROM [Sheet1$]' ) as a Please help me decide.. Access 2010 doesn't want to link either.

Answer 1

Can someone help?

Answer 2

Microsoft Access Database Engine must be installed
https://www.microsoft.com/en-us/download/details.a...
of the same bitness as sql server.
After successful installation, the Microsoft.ACE.OLEDB.12.0 driver should appear in server objects/linked server/providers