Microsoft Jet OLE DB 4.0

This OLE DB Provider is provided by Microsoft. The main functionality of the provider is contained in the file msjetoledb40.dll.

Include "Provider=Microsoft.Jet.OLEDB.4.0" in the connection string to use this provider.

Download

There is no 'Microsoft Jet OLE DB 4.0' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The Microsoft Jet OLE DB 4.0 provider can be used to connect to the following data sources by using the following connection string references:

ParadoxExcelExcel 97Excel 2000Excel 2002Excel 2003TextfileAccessAccess 97Access 2000Access 2002Access 2003DBF / FoxProHTML Table

Providers

CData ADO.NET Provider for Excel Microsoft ACE OLEDB 12.0 Microsoft Access ODBC Driver .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC Microsoft Excel ODBC Driver .NET xlReader for Microsoft Excel Microsoft Access accdb ODBC Driver Microsoft Excel 2007 ODBC Driver Microsoft Paradox Driver Microsoft Text ODBC Driver Microsoft dBASE ODBC Driver Intersolv 3.11 ODBC Driver .NET txtReader for Text Files

Articles

read all »
Jet for Access, Excel and Txt on 64 bit systems The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Open a password-protected Excel workbook Formating Rules for Connection Strings Connection Strings Explained Store Connection String in Web.config Connection Pooling The Provider Keyword, ProgID, Versioning and COM CLSID Explained Store and read connection string in appsettings.json SQL Server Data Types Reference