This documentation is archived and is not being maintained.

XlParameterDataType Enumeration

Office 2007
Specifies the data type of a query parameter.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlParamTypeBigInt-5Big integer.
xlParamTypeBinary-2Binary.
xlParamTypeBit-7Bit.
xlParamTypeChar1String.
xlParamTypeDate9Date.
xlParamTypeDecimal3Decimal.
xlParamTypeDouble8Double.
xlParamTypeFloat6Float.
xlParamTypeInteger4Integer.
xlParamTypeLongVarBinary-4Long binary.
xlParamTypeLongVarChar-1Long string.
xlParamTypeNumeric2Numeric.
xlParamTypeReal7Real.
xlParamTypeSmallInt5Small integer.
xlParamTypeTime10Time.
xlParamTypeTimestamp11Time stamp.
xlParamTypeTinyInt-6Tiny integer.
xlParamTypeUnknown0Type unknown.
xlParamTypeVarBinary-3Variable-length binary.
xlParamTypeVarChar12Variable-length string.
xlParamTypeWChar-8Unicode character string.


Show: