The following table shows how the text file data types are mapped to the standard ODBC data types.

Table 1. Text Data Types
Text ODBC
Numeric SQL_NUMERIC
Date SQL_TYPE_DATE
Varchar SQL_VARCHAR

See Retrieving Data Type Information for information about retrieving data types.