Share 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)

Usage

Dim xlParameterDataType1 As XlParameterDataType = XlParameterDataType.xlParamTypeBigInt

Syntax

Public Enum XlParameterDataType
public enum XlParameterDataType
public enum class XlParameterDataType
public enum XlParameterDataType
public enum XlParameterDataType

Members

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

Platforms

Development Platforms

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

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace