ODBC Driver for Excel Services

Build 20.0.7587

Data Type Mapping

Data Type Mappings

The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.

Excel Services (OData V3) Excel Services (OData V4) CData Schema
Edm.Binary Edm.Binary binary
Edm.Boolean Edm.Boolean bool
Edm.DateTime Edm.DateTimeOffset datetime
Edm.Double Edm.Double double
Edm.Guid Edm.Guid guid
Edm.Int32 Edm.Int32 int
Edm.String Edm.String string
Edm.TimeOfDay Edm.TimeOfDay time

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