This article is a generic article which talk about the Excel datatype.
The following table shows how Microsoft Excel driver data types are mapped to ODBC SQL data types. The Microsoft Excel driver assigns these data types to columns in Microsoft Excel tables based on the data in the column.
| Microsoft Excel data type | ODBC data type |
|---|---|
| CURRENCY | SQL_NUMERIC |
| DATETIME | SQL_TIMESTAMP |
| LOGICAL | SQL_BIT |
| NUMBER | SQL_DOUBLE |
| TEXT | SQL_VARCHAR |
The DATE and TIMESTAMP data type cannot be converted to another data type (or itself) by the CONVERT function.