Microsoft Excel to TDV Data Types
The following table shows the mapping from Microsoft Excel data types to TDV data types.
Note: The NUMBER data types returned from the JDBC/ODBC driver do not accurately reflect the real precision and scale if you have formatted the cells in Excel with the following categories: NUMBER, PERCENTAGE, SCIENTIFIC, and FRACTION.
Microsoft Excel Data Type | TDV Data Type |
BIT | BIT |
BIGINT | BIGINT |
CURRENCY | DOUBLE |
DATETIME | TIMESTAMP |
NUMBER | DOUBLE |
VARCHAR | VARCHAR(32676) |