ODBC Driver for Excel Services

Build 20.0.7587

Getting Started

The CData ODBC Driver for Excel Services 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).

Excel Services Version Support

The driver supports retrieving Excel data from SharePoint On-Premises and SharePoint Online, through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.

See Also

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587