This documentation is archived and is not being maintained.

XlParameterDataType Enumeration 

Specifies the data type of a query parameter.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim xlParameterDataType1 As XlParameterDataType = XlParameterDataType.xlParamTypeBigInt

public enum XlParameterDataType
public enum XlParameterDataType
public enum XlParameterDataType

Member nameDescription
xlParamTypeBigIntBig integer.
xlParamTypeBinaryBinary.
xlParamTypeBitBit.
xlParamTypeCharString.
xlParamTypeDateDate.
xlParamTypeDecimalDecimal.
xlParamTypeDoubleDouble.
xlParamTypeFloatFloat.
xlParamTypeIntegerInteger.
xlParamTypeLongVarBinaryLong binary.
xlParamTypeLongVarCharLong string.
xlParamTypeNumericNumeric.
xlParamTypeRealReal.
xlParamTypeSmallIntSmall integer.
xlParamTypeTimeTime.
xlParamTypeTimestampTime stamp.
xlParamTypeTinyIntTiny integer.
xlParamTypeUnknownType unknown.
xlParamTypeVarBinaryVariable-length binary.
xlParamTypeVarCharVariable-length string.
xlParamTypeWCharUnicode character string.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: