It is a 32-bit vs 64-bit issue.
You may try to install the Microsoft.ACE.OLEDB Provider for Both 64-bit and 32-bit.
Here is a blog you may take a reference.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi All, I'm attempting to import data into SQL Server from an Excel spreadsheet, but I consistently encounter an error message stating: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" from the System.Data namespace. I use SQL server management studio (v18.10) and microsoft excel (version 2302 Build 16.0.16130.20848) 64-bit Could someone kindly assist me with resolving this issue. Thanks
It is a 32-bit vs 64-bit issue.
You may try to install the Microsoft.ACE.OLEDB Provider for Both 64-bit and 32-bit.
Here is a blog you may take a reference.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.