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

Hi @Colin De Villiers , Welcome to Microsoft Q&A,

A simple and effective way is to uncheck Prefer 32-bit in the project properties compile page.

https://answers.microsoft.com/en-us/msoffice/forum/all/the-microsoftaceoledb120-provider-is-not/b23bce3a-fa46-495c-90d2-f763a77f376e

Microsoft has removed the download link for Microsoft.ACE.OLEDB.12.0.

12.0 is available for Office 2007-2010.

The latest version is currently Microsoft.ACE.OLEDB.16.0.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Best Regards,

Jiale

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.