Save Big on Cyber Monday! Up to 40% Off
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

ODBC Driver for Microsoft Excel

High-performance data integration tool for developers and data analysts working with Microsoft Excel that helps quickly and easily solve business challenges related to data transmission.

Devart ODBC Driver fully supports standard ODBC API functions and data types and enables straightforward and secure access to live Microsoft Excel data from anywhere.

Supported platforms
  • Simple installation on multiple computers
  • Easy access to real-time data from anywhere
  • Support for bulk operations for improved efficiency
  • Regular software releases

Microsoft Excel data integration

Access Microsoft Excel data from BI platforms, analytics tools, ETL systems, and database applications using Devart ODBC Driver for Excel. This integration allows you to:

  • Query Excel sheets using SQL, including JOINs, filtering, grouping, and sorting.
  • Use Excel files as data sources without installing Microsoft Excel or other dependencies.
  • Read from and write to modern Excel formats (.xlsx, .xlsm) and legacy formats (.xls).
  • Automate integration workflows by treating Excel data as database tables in reporting and data pipelines.

Extended SQL syntax

Devart ODBC Driver offers an unparalleled opportunity to work with Microsoft Excel as if it were a SQL database. The extended SQL syntax supports SQL-92 compliant SELECT statements, allowing you to benefit from all the advantages of SQL for data querying and manipulation.

  • Complex JOINs
  • WHERE conditions
  • Subqueries
  • GROUP statements
  • Aggregation functions
  • ORDER statements
  • ...and many more
Explore the OEM licensing model
Explore the OEM licensing model
Get a personal consultation and discover how our ODBC Driver can streamline your database development.
Request a quote
Get started with ODBC Driver at no cost
Get started with the ODBC Driver at no cost
Download a FREE, fully functional trial version and elevate your data integration capabilities today!
Download free trial

Features Overview

ODBC Conformance

ODBC conformance

ODBC driver for Microsoft Excel provides full support for common ODBC interface:
  • ODBC API Functions support
  • ODBC Data Types support
In addition, we provide support for Advanced Connection String parameters, thus allowing any desktop and web applications to connect to Microsoft Excel from various environments and platforms that support ODBC.
DML Operations

DML Operations

Devart ODBC Driver for Microsoft Excel provides support for DML:
  • INSERT
  • UPDATE
  • DELETE
This allows you to modify data in Microsoft Excel the same way as in SQL databases.
Microsoft Excel Compatibility

Microsoft Excel compatibility

Our ODBC driver fully supports all Microsoft Excel field data types and is compatible with the following Microsoft Excel versions:
  • Microsoft Excel database: 2007 - 2021
  • Microsoft Excel 97 - 2003 (in read-only mode)
  • Apache OpenOffice Calc
  • LibreOffice Calc
Advanced Data Conversion

Advanced data conversion

We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any Microsoft Excel and ODBC data types.
Support

Support

Visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.
High Performance

High performance

Every operation with Microsoft Excel becomes significantly faster using such capabilities of our ODBC driver for Microsoft Excel as local data caching, connection pooling, and much more.

ODBC Universal Bundle

Get ODBC Drivers for 92 databases and cloud applications in a single
Universal Bundle with a 95% discount.

Other ODBC Drivers for Databases