none
Connection string for Office 2019 RRS feed

  • Question

  • I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database.  For .xls files, I use the connection string:
    Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...; Extended Properties Excel 8.0;
    for .xlsx files, I use
    Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...; Extended Properties Excel 12.0 Xml;

    All works great on Win 7 PCs and Windows 10 with Office 2016.  HOWEVER, I installed my app on my new Windows 10 PC with Office 2019 and the app fails with the error

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

    My internet search told me to try installing Microsoft Access database engine 2010 but that did not work.  Since I had Office 2019 installed, why not change my connection string to
    Provider=Microsoft.ACE.OLEDB.16.0;Data Source= ...; Extended Properties Excel 16.0 Xml;
    but that did not work either.  Error was
    The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine.

    I would think that a new Windows 10 with Office 2019 would have an Access OLEDB provider installed already.  I've never had to register a provider on any PC that I tried to run my program on.  Can't find much on the internet about Office 2019.  Is there a connection string for Office 2019 that does work?  Any insight would be appreciated.
    Wednesday, May 8, 2019 2:15 AM

All replies