G
Gunner359
Guest
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.
Continue reading...
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.
Continue reading...