Microsoft Excel 2007 ODBC Driver

This ODBC Driver is provided by Microsoft.

Include "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" in the connection string to use this driver.

Description

This driver was first released with Office 2007. It is possible to use this driver to connect to old xls files as well. The driver is available in both 32 bit and 64 bit versions.

Download

This ODBC Driver, Microsoft Excel 2007 ODBC Driver, can be downloaded here.

Connection Strings

The Microsoft Excel 2007 ODBC Driver driver can be used to connect to the following data sources by using the following connection string references:

ExcelExcel 97Excel 2000Excel 2002Excel 2003Excel 2007Excel 2010Excel 2013

Providers

CData ADO.NET Provider for Excel Microsoft ACE OLEDB 12.0 .NET xlReader for Microsoft Excel Microsoft Jet OLE DB 4.0 Microsoft Excel ODBC Driver .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC

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