Expand Minimize

XlParameterDataType Enumeration (Excel)

Specifies the data type of a query parameter.

Version Added: Excel 2007

Name

Value

Description

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.

Show:
© 2014 Microsoft