Export (0) Print
Expand All
Expand Minimize

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.


Community Additions

ADD
Show:
© 2014 Microsoft