Excel - Datatype

Card Puncher Data Processing

About

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

Management

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

Convert

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

Documentation / Reference





Discover More
Card Puncher Data Processing
Excel - Date Time

Excel has only one time data type, it's a timestamp.
Odbc Excel Driver Setup
Excel - ODBC Driver

This article talk the Odbc Excel driver. For more information, you can check the Microsoft Excel Driver Programming Documentation The...
Card Puncher Data Processing
Microsoft Excel

Excel is a spreadsheet tool that you can categorize in the desktop database. It's a reactive tool (a cell update is reflected in all dependent cell). Lukas...



Share this page:
Follow us:
Task Runner