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

Question

i want read uploaded excel data into datatable . its working on my local but not working on hosted server

showing error : " The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine "

Answer 1

Hello,

I have encounter this problem, hope this solution can help you.

1st- check Microsoft Office 32bit or 64bit.

Note: On the Mac, there is no choice between running a 32-bit or 64-bit version of the operating system, since the OS has been 64-bit for several

years. Office for Mac 2011 was only available in a 32-bit version, and Office for Mac 2016 is now only available in a 64-bit version.

2nd- Install Access Database Engine. I give you the link. https://www.microsoft.com/en-us/download/details.aspx?id=54920 and click download and it's better to download 64bit.

3rd - Open your Visual Studio Project, Right click and locate the properties of the project.

4th - Proceed to build TAB, next look "Platform Target". In default that combobox is selected "ANY CPU" and the checkbox Prefer 32-bit is check. Now all you need to do is change that combobox in to 64bit (x64) and don't check any check box. Close the Visual Studio or restart pc thin open it again.

--If the reply is helpful, please Upvote and Accept as answer--