

During the past thirty years, Microsoft Office has evolved from a simple text editor to a powerful combination of desktop apps and cloud services.

Is there a connection string for Office 2019 that does work? Any insight would be appreciated.Īccess ×159 Access 2000 ×8 Access 2002 ×4 Access 2003 ×15 Access 2007 ×29 Access 2010 ×29 Access 2013 ×45 Access 97 ×6 Active Directory ×8 AS/400 ×13 Azure SQL Database ×20 Caché ×1 Composite Information Server ×2 ComputerEase ×2 DBF / FoxPro ×20 DBMaker ×1 DSN ×21 Excel ×125 Excel 2000 ×2 Excel 2002 ×2 Excel 2003 ×10 Excel 2007 ×16 Excel 2010 ×22 Excel 2013 ×28 Excel 97 ×4 Exchange ×1 Filemaker ×1 Firebird ×8 HTML Table ×3 IBM DB2 ×16 Informix ×8 Integration Services ×5 Interbase ×2 Intuit QuickBase ×1 Lotus Notes ×3 Mimer SQL ×1 MS Project ×2 MySQL ×60 Netezza DBMS ×4 OData ×3 OLAP, Analysis Services ×3 OpenOffice SpreadSheet ×2 Oracle ×62 Paradox ×3 Pervasive ×6 PostgreSQL ×19 Progress ×4 SAS ×5 SAS IOM ×1 SAS OLAP ×2 SAS Workspace ×2 SAS/SHARE ×2 SharePoint ×17 SQL Server ×208 SQL Server 2000 ×8 SQL Server 2005 ×13 SQL Server 2008 ×51 SQL Server 2012 ×35 SQL Server 2014 ×9 SQL Server 2016 ×12 SQL Server 2017 ×2 SQL Server 2019 ×2 SQL Server 7.The first Microsoft Office product was announced back in 1988. The '.16.0' provider is not registered on the local Since I had Office 2019 installed, why not change my connection string to Provider=.16.0 Data Source=. My internet search told me to try installing Microsoft Access database engine 2010 but that did not work. The '.12.0' provider is not registered on the local HOWEVER, I installed my app on my new Windows 10 PC with Office 2019 and the app fails with the error Extended Properties Excel 12.0 Xml Īll works great on Win 7 PCs and Windows 10 with Office 2016.

NET program using VS17 that opens Excel files and loads the data into an Access database.
