DELETE FROM [RC_Data]
INSERT INTO [RC_Data] SELECT * FROM OPENQUERY(LNKEXCEL,'SELECT * FROM [RC_Data_Result$]')

OLE DB error trace [Non-interface error:  Provider not registered.].
Сообщение 7403, уровень 16, состояние 1, строка 1
Could not locate registry entry for OLE DB provider 'Microsoft.ACE.OLEDB.12.0'.

Provider Name	Provider Description
SQLOLEDB	Microsoft OLE DB Provider for SQL Server
DTSPackageDSO	Microsoft OLE DB Provider for DTS Packages
SQLReplication.OLEDB	SQL Server Replication OLE DB Provider for DTS
MSDMine	Microsoft OLE DB Provider For Data Mining Services
MSOLAP	Microsoft OLE DB Provider for Analysis Services 11.0
Microsoft.ACE.OLEDB.15.0	Microsoft Office 15.0 Access Database Engine OLE DB Provider
Microsoft.ACE.OLEDB.16.0	Microsoft Office 16.0 Access Database Engine OLE DB Provider
EMPOLEDBVS71.1	VSEE Versioning Enlistment Manager Proxy Data Source
ADsDSOObject	OLE DB Provider for Microsoft Directory Services
SQLNCLI10	SQL Server Native Client 10.0
Search.CollatorDSO.1	Microsoft OLE DB Provider for Search
MSOLAP	Microsoft OLE DB Provider for OLAP Services 8.0
MSDASQL	Microsoft OLE DB Provider for ODBC Drivers
Microsoft.Jet.OLEDB.4.0	Microsoft Jet 4.0 OLE DB Provider
MSDAOSP	Microsoft OLE DB Simple Provider
MSDAORA	Microsoft OLE DB Provider for Oracle
MSIDXS	Microsoft OLE DB Provider for Indexing Service

/****** Object:  LinkedServer [LNKEXCELNEW]    Script Date: 01/21/2019 16:02:02 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'LNKEXCELNEW', @srvproduct=N'ExcelTable', @provider=N'Microsoft.ACE.OLEDB.15.0', @datasrc=N'C:\Work\Filename.xlsm', @provstr=N'Excel 15.0 Macro'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LNKEXCELNEW',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'LNKEXCELNEW', @optname=N'use remote collation', @optvalue=N'true'
GO

DELETE FROM [RC_Data]
INSERT INTO [RC_Data] SELECT * FROM OPENQUERY(LNKEXCELNEW,'SELECT * FROM [RC_Data_Result$]')

OLE DB error trace [OLE/DB Provider 'Microsoft.ACE.OLEDB.15.0' IDBInitialize::Initialize returned 0x80004005:  The provider did not give any information about the error.].
Сообщение 7399, уровень 16, состояние 1, строка 2
OLE DB provider 'Microsoft.ACE.OLEDB.15.0' reported an error. The provider did not give any information about the error.