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.