Edit

XlParameterDataType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the data type of a query parameter.

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

Fields

xlParamTypeBigInt -5

Big integer.
xlParamTypeBinary -2

Binary.
xlParamTypeBit -7

Bit.
xlParamTypeChar 1

String.
xlParamTypeDate 9

Date.
xlParamTypeDecimal 3

Decimal.
xlParamTypeDouble 8

Double.
xlParamTypeFloat 6

Float.
xlParamTypeInteger 4

Integer.
xlParamTypeLongVarBinary -4

Long binary.
xlParamTypeLongVarChar -1

Long string.
xlParamTypeNumeric 2

Numeric.
xlParamTypeReal 7

Real.
xlParamTypeSmallInt 5

Small integer.
xlParamTypeTime 10

Time.
xlParamTypeTimestamp 11

Time stamp.
xlParamTypeTinyInt -6

Tiny integer.
xlParamTypeUnknown 0

Type unknown.
xlParamTypeVarBinary -3

Variable-length binary.
xlParamTypeVarChar 12

Variable-length string.
xlParamTypeWChar -8

Unicode character string.

Applies to