'VarType Code Description
'adBigInt 20 Indicates an eight-byte signed integer (DBTYPE_I8).
'adBinary 128 Indicates a binary value (DBTYPE_BYTES).
'adBoolean 11 Indicates a boolean value (DBTYPE_BOOL).
'adBSTR 8 Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR).
'adChapter 136 Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER).
'adChar 129 Indicates a string value (DBTYPE_STR).
'adCurrency 6 Indicates a currency value (DBTYPE_CY). Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000.
'adDate 7 Indicates a date value (DBTYPE_DATE). A date is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day.
'adDBDate 133 Indicates a date value (yyyymmdd) (DBTYPE_DBDATE).
'adDBTime 134 Indicates a time value (hhmmss) (DBTYPE_DBTIME).
'adDBTimeStamp 135 Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP).
'adDecimal 14 Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL).
'adDouble 5 Indicates a double-precision floating-point value (DBTYPE_R8).
'adEmpty 0 Specifies no value (DBTYPE_EMPTY).
'adError 10 Indicates a 32-bit error code (DBTYPE_ERROR).
'adFileTime 64 Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME).
'adGUID 72 Indicates a globally unique identifier (GUID) (DBTYPE_GUID).
'adIDispatch 9 Indicates a pointer to an IDispatch interface on a COM object (DBTYPE_IDISPATCH).
'Note - This data type is currently not supported by ADO. Usage may cause unpredictable results.
'adInteger 3 Indicates a four-byte signed integer (DBTYPE_I4).
'adIUnknown 13 Indicates a pointer to an IUnknown interface on a COM object (DBTYPE_IUNKNOWN).
'adLongVarBinary 205 Indicates a long binary value (Parameter object only).
'adLongVarChar 201 Indicates a long string value (Parameter object only).
'adLongVarWChar 203 Indicates a long null-terminated Unicode string value (Parameter object only).
'adNumeric 131 Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).
'adPropVariant 138 Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT).
'adSingle 4 Indicates a single-precision floating-point value (DBTYPE_R4).
'adSmallInt 2 Indicates a two-byte signed integer (DBTYPE_I2).
'adTinyInt 16 Indicates a one-byte signed integer (DBTYPE_I1).
'adUnsignedBigInt 21 Indicates an eight-byte unsigned integer (DBTYPE_UI8).
'adUnsignedInt 19 Indicates a four-byte unsigned integer (DBTYPE_UI4).
'adUnsignedSmallInt 18 Indicates a two-byte unsigned integer (DBTYPE_UI2).
'adUnsignedTinyInt 17 Indicates a one-byte unsigned integer (DBTYPE_UI1).
'adUserDefined 132 Indicates a user-defined variable (DBTYPE_UDT).
'adVarChar 204 Indicates a binary value (Parameter object only).
'adVariant 200 Indicates a string value (Parameter object only).
'adVarNumeric 12 Indicates an Automation Variant (DBTYPE_VARIANT).
'adVarWChar 139 Indicates a numeric value (Parameter object only).
'adWChar 202 Indicates a null-terminated Unicode character string (Parameter object only).
'adVarBinary 130 Indicates a null-terminated Unicode character string (DBTYPE_WSTR).