XlParameterDataType Enumeration

Excel Developer Reference

Specifies the data type of a query parameter.

Version Information
 Version Added:  Excel 2007

Name Value Description
xlParamTypeBigInt -5 Big integer.
xlParamTypeBinary -2 Binary.
xlParamTypeBit -7 Bit.
xlParamTypeChar 1 String.
xlParamTypeDate 9 Date.
xlParamTypeDecimal 3 Decimal.
xlParamTypeDouble 8 Double.
xlParamTypeFloat 6 Float.
xlParamTypeInteger 4 Integer.
xlParamTypeLongVarBinary -4 Long binary.
xlParamTypeLongVarChar -1 Long string.
xlParamTypeNumeric 2 Numeric.
xlParamTypeReal 7 Real.
xlParamTypeSmallInt 5 Small integer.
xlParamTypeTime 10 Time.
xlParamTypeTimestamp 11 Time stamp.
xlParamTypeTinyInt -6 Tiny integer.
xlParamTypeUnknown 0 Type unknown.
xlParamTypeVarBinary -3 Variable-length binary.
xlParamTypeVarChar 12 Variable-length string.
xlParamTypeWChar -8 Unicode character string.