Search code examples
asp.netsql-server-2005oledbsqlbulkcopy

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


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


Solution

  • 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.