The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

asp.net oledb sqlbulkcopy sql-server-2005

Question

i have followed the answer to this thread C# import excel filesheet to sql database error and am able to import excel data into an SQL Server Database. The only problem am having is that the Import works only when am running the website locally from Development machine but after deploying the site to IIS, i get the following error when trying to import the data from excel.

enter image description here

Accepted Answer

The server is missing the required DLL. You can find an install only here.

This download will install a set of components that can be used to facilitate transfer of data between 2007 Microsoft Office System files and non-Microsoft Office applications.




Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why