Unable to import from Microsoft excel RRS feed

  • Question

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

    Saturday, November 28, 2020 10:03 PM

All replies

  • 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

    Saturday, November 28, 2020 10:48 PM