Features

• 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 - The ODBC driver provides the opportunity to work with Microsoft Excel as if it were a SQL database. The extended SQL syntax supports SQL-92 compatible 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.
• ODBC conformance - ODBC driver for Microsoft Excel provides full support for common ODBC interface:
  • ODBC API Functions support.
  • ODBC Data Types support.
  • In addition, support is provided for Advanced Connection String parameters, allowing any desktop and web applications to connect to Microsoft Excel from various environments and platforms that support ODBC.
• DML Operations - Devart ODBC Driver for Microsoft Excel provides support for DML which allows you to modify data in Microsoft Excel the same way as in SQL databases:
  • INSERT.
  • UPDATE.
  • DELETE.
• Advanced data conversion - Advanced Data Conversion mechanisms have been implemented that provide bi-directional mapping between any Microsoft Excel and ODBC data types.
• High Performance - Every operation with Microsoft Excel becomes significantly faster using features such as local data caching, connection pooling, and much more.
• Real-time data integration with 3rd party tools tools - Devart ODBC drivers are verified to be compatible with 250+ leading analytics and reporting tools, various IDEs, and programming languages. Get fast and secure access to your data in any application:
  • Database Management Software
    • SQL Server Management Studio (SSMS)
    • Microsoft Access
    • DBeaver
    • RazorSQL
    • and others
  • Business Intelligence & Analytics Software
    • Power BI
    • Tableau
    • QlikView
    • TIBCO Spotfire
    • and others
  • Document Management Software
    • Microsoft Excel
    • LibreOffice
    • OpenOffice
    • StarOffice
    • and others
  • Application Development Tools
    • Microsoft Visual Studio
    • Python, PHP
    • FileMaker
    • C++ Builder
    • and others