ODBC Driver for Microsoft Excel

Build 24.0.8963

Getting Started

The CData ODBC Driver for Microsoft Excel is a standards-based ODBC driver with editions for Windows and Unix-based operating systems, like macOS and Linux. The following sections show how to create an ODBC data source and query data.

Creating a DSN on Your Platform

The following guides show how to use the standard tools to configure data source names (DSN).

Microsoft Excel Version Support

The CData ODBC Driver for Microsoft Excel supports the Office Open XML spreadsheets used by Microsoft Excel 2007 and later.

Microsoft Excel File Extension Support

The CData ODBC Driver for Microsoft Excel currently supports .xlsx and .xlsm files. However, only read operations are supported for .xlsm files. Modifying data operations may cause loss of or damage to macros.

See Also

See the following sections to connect to the DSN from tools and from code:

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963