|
ODBC Driver for Microsoft Excel Supported Data Types - ODBC Driver for Microsoft Excel |
|
|
|
ODBC Driver for Microsoft Excel Supported Data Types - ODBC Driver for Microsoft Excel |
|
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 |