OLEDB Error: Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.16.0 for linked server (null)

Last Reply one month ago By pandeyism

Posted one month ago

Hi Mr.Muddassr

Previously , we are using upload excel by using your code (below link) and working fine. Thank  you very much.

Previosly MSSQL 2012 and Visual Studio 2014, MS Office 2010

Import Excel data to SQL Server Database using Stored Procedure in ASP.Net

But now, our client upgrade to MS Office 2016 and MsSQL 2017 and VS 2017. Currently we have error 

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.16.0" for linked server "(null)". OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" 

Please advice me how to solve 

Thank you

Maideen