Partager via


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)

Syntax

'Declaration
Public Enumeration XlParameterDataType
'Usage
Dim instance As XlParameterDataType
public enum XlParameterDataType

Members

Member name Description
xlParamTypeUnknown Type unknown.
xlParamTypeChar String.
xlParamTypeNumeric Numeric.
xlParamTypeDecimal Decimal.
xlParamTypeInteger Integer.
xlParamTypeSmallInt Small integer.
xlParamTypeFloat Float.
xlParamTypeReal Real.
xlParamTypeDouble Double.
xlParamTypeVarChar Variable-length string.
xlParamTypeDate Date.
xlParamTypeTime Time.
xlParamTypeTimestamp Time stamp.
xlParamTypeLongVarChar Long string.
xlParamTypeBinary Binary.
xlParamTypeVarBinary Variable-length binary.
xlParamTypeLongVarBinary Long binary.
xlParamTypeBigInt Big integer.
xlParamTypeTinyInt Tiny integer.
xlParamTypeBit Bit.
xlParamTypeWChar Unicode character string.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace