Google quickly finds that 'currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS.' Also found this which might help; Jet for Access, Excel and Txt on 64 bit systems - ConnectionStrings.com.
- How to resolve error message 'The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.' Here is step by step solution for 'The 'Microsof.
- In this article. Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse The OLE DB Driver for SQL Server is a stand-alone data access application programming interface (API), used for OLE DB.
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Introduction
The Microsoft OLE DB Provider for Microsoft Jet and the Microsoft Access ODBC driver (Jet ODBC driver) provide an interface to Microsoft Office Access databases. The Microsoft OLE DB Provider for Jet and the Jet ODBC driver are available in 32-bit versions only.
For example, you have a 32-bit application that uses the Microsoft OLE DB Provider for Jet. If you migrate the application to run in the 64-bit mode, the application can't connect to the data source by using the Microsoft OLE DB Provider for Jet. This issue occurs because the application requires a 64-bit version of the Microsoft OLE DB Provider for Jet.
However, you can still use the 32-bit version of the Microsoft OLE DB Provider for Jet and the 32-bit version of the Jet ODBC driver. In a 64-bit Windows environment, you can run an application in the 32-bit mode. This enables the application to use the 32-bit version of the Microsoft OLE DB Provider for Jet or the 32-bit version of the Jet ODBC driver.
More information
The Jet Database Engine was designed to be a general-purpose database engine that's supplied together with Windows. The Access Database Engine, also called Access Connectivity Engine (ACE), is the Office database engine that's built from the foundation of Jet. ACE is provided in both 32-bit and 64-bit architectures. However, only one architecture is allowed on a device. The architecture of ACE must match the architecture of the Office installation on that computer. Both engines provide similar functionality, but ACE follows the design principles of Office and isn't suited for some of the previous scenarios that are supported by Jet. To make sure that ACE is the best solution for your scenario, read through all the intended use scenarios that are provided on the download page, Download Microsoft Access Database Engine 2016 Redistributable.
To determine whether ACE is already available on your computer, or which installation is recommended, see Unable to use the Access ODBC, OLEDB, or DAO interfaces outside Office Click-to-Run applications.
-->Note
Microsoft Jet Oledb 4.0 Download
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Introduction
The Microsoft OLE DB Provider for Microsoft Jet and the Microsoft Access ODBC driver (Jet ODBC driver) provide an interface to Microsoft Office Access databases. The Microsoft OLE DB Provider for Jet and the Jet ODBC driver are available in 32-bit versions only.
For example, you have a 32-bit application that uses the Microsoft OLE DB Provider for Jet. If you migrate the application to run in the 64-bit mode, the application can't connect to the data source by using the Microsoft OLE DB Provider for Jet. This issue occurs because the application requires a 64-bit version of the Microsoft OLE DB Provider for Jet.
However, you can still use the 32-bit version of the Microsoft OLE DB Provider for Jet and the 32-bit version of the Jet ODBC driver. In a 64-bit Windows environment, you can run an application in the 32-bit mode. This enables the application to use the 32-bit version of the Microsoft OLE DB Provider for Jet or the 32-bit version of the Jet ODBC driver.
More information
The Jet Database Engine was designed to be a general-purpose database engine that's supplied together with Windows. The Access Database Engine, also called Access Connectivity Engine (ACE), is the Office database engine that's built from the foundation of Jet. ACE is provided in both 32-bit and 64-bit architectures. However, only one architecture is allowed on a device. The architecture of ACE must match the architecture of the Office installation on that computer. Both engines provide similar functionality, but ACE follows the design principles of Office and isn't suited for some of the previous scenarios that are supported by Jet. To make sure that ACE is the best solution for your scenario, read through all the intended use scenarios that are provided on the download page, Download Microsoft Access Database Engine 2016 Redistributable.
Install Microsoft Jet Oledb 4.0
To determine whether ACE is already available on your computer, or which installation is recommended, see Unable to use the Access ODBC, OLEDB, or DAO interfaces outside Office Click-to-Run applications.