ODBC Driver for Microsoft Excel

Supported Data Types - ODBC Driver for Microsoft Excel

Data Type Mapping

The Devart ODBC Driver for Microsoft Excel supports all Microsoft Excel data types.

The following table describes how the Microsoft Excel data types are mapped to the ODBC data types.

Microsoft Excel Data Types ODBC Data Types

boolean

SQL_BIT

integer

SQL_INTEGER

float

SQL_DOUBLE

date

SQL_TYPE_DATE

time

SQL_TYPE_TIME

datetime

SQL_TYPE_TIMESTAMP

string

SQL_VARCHAR

© 2015-2025 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback