Unable to import from Microsoft excel

Question

Microsoft.ACE.OLEDB.12.0 Provider is not registered on the local computer

Answer 1

You don't need to use an OLEDB provider to import from Excel.

Instead just use the import data wizard.

Using Access 2016/2019/365 click External Data ... New Data Source ...From File ...Excel

A similar path will work in earlier versions such as Access 2010