Excel - Datatype

1 - About

This article is a generic article which talk about the Excel datatype.

3 - Management

3.1 - List

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

3.2 - Convert

The DATE and TIMESTAMP data type cannot be converted to another data type (or itself) by the CONVERT function.

4 - Documentation / Reference

db/excel/datatype.txt ยท Last modified: 2018/07/03 17:06 by gerardnico