About this product
The Devart ODBC Driver for Microsoft Excel lets any ODBC-compliant application work with Excel workbooks as if they were database tables. You can query and change spreadsheet data with SQL: SELECT with JOINs, WHERE filters, subqueries, GROUP BY and aggregate functions, plus INSERT, UPDATE and DELETE.
The driver reads and writes .xlsx and .xlsm files and can read legacy .xls files (Excel 97–2003). Microsoft Excel doesn't need to be installed. Bulk operations, local data caching and connection pooling speed up data access. The driver supports the full ODBC API and converts between Excel and ODBC data types.
Who it is for
- Analysts who bring Excel data into BI and reporting tools such as Power BI, Tableau or QlikView
- Developers who work with Excel files over ODBC from Python, PHP or Visual Studio
- Database administrators who use Excel data in SSMS, Microsoft Access, DBeaver or LibreOffice
Licensing
The Desktop edition covers one desktop computer, used by one person at a time. There are separate options for Windows, macOS and Linux. Choose the one for the operating system the driver will run on.
- Perpetual License: Lets you use the purchased version with no time limit and includes 12 months of updates. The "plus 2 years" and "plus 3 years of Support & upgrade information" options extend that period to two or three years.
- Perpetual Renewal: Adds one, two or three more years of updates and support to an existing perpetual license.
- Subscription: Lets you use the driver for one, two or three years. When the term ends, you need to renew to keep using it. Activation requires an internet connection.
- Premium Support included: These options also include an extended support package from Devart.
Delivery
Delivery is electronic (ESD). After your order is processed, you receive the license details and download information by email.