Indicates whether the Jet validation rules are evaluated when column data is set or when the changes are committed to the database. By default, the OLE DB Provider for Microsoft Jet opens Microsoft Jet databases in read/write mode. To open a database in read-only mode, set the Mode property on the ADO Connection object to adModeRead. Import data from Excel to new SQL Server table Excel 2003 (.Xls) file: select. into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D: testing.xls;HDR=YES', 'SELECT. FROM Sheet1$') Excel 2007 (.Xlsx) file. Problem:I have a webapp which uses the Microsoft.Jet.OLEDB.4.0 driver to import and read an Excel file. The code was working fine till we ran into an issue with our webserver and had to use the aspnetregiis tool on our web server to fix the issue.

• Install Microsoft Jet Oledb 4.0
• Microsoft.jet.oledb.4.0 Excel 8.0 Download
• Microsoft Jet Oledb Provider Download
• Microsoft.jet.oledb.4.0 Excel Download Free
• Microsoft.jet.oledb.4.0 Excel Download Full

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. OLE DB Driver for SQL Server is available on Windows and delivers the SQL OLE DB driver in one dynamic-link library (DLL).

Download

The redistributable installer for Microsoft OLE DB Driver for SQL Server installs the client components required during run time to take advantage of newer SQL Server features. Starting with version 18.3, the installer also includes and installs the Microsoft Active Directory Authentication Library (ADAL.dll).

Microsoft OLE DB Driver 18.6 for SQL Server is the latest general availability (GA) version. If you have a previous version of Microsoft OLE DB Driver 18 for SQL Server installed, installing 18.6 upgrades it to 18.6.

Download Microsoft OLE DB Driver for SQL Server (x64)
Download Microsoft OLE DB Driver for SQL Server (x86)

Version information

• Release number: 18.6.0
• Released: June 18, 2021

Note

If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the US-English version of the site. You can download different languages from the US-English version site by selecting available languages.

Available languages

Install Microsoft Jet Oledb 4.0

This release of Microsoft OLE DB Driver for SQL Server can be installed in the following languages:

Microsoft OLE DB Driver 18.6 for SQL Server (x64):
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Microsoft.jet.oledb.4.0 Excel 8.0 Download

Microsoft OLE DB Driver 18.6 for SQL Server (x86):
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Release notes

Microsoft Jet Oledb Provider Download

For details about this release, see the release notes.

Previous releases

Microsoft.jet.oledb.4.0 Excel Download Free

See also

Microsoft.jet.oledb.4.0 Excel Download Full

Release notes for the Microsoft OLE DB Driver for SQL Server
System requirements for OLE DB Driver for SQL Server
Support policies for OLE DB Driver for SQL Server
When to use OLE DB Driver for SQL Server
Installing OLE DB Driver for SQL Server