XlParameterDataType Enumeration
Specifies the data type of a query parameter.
Version Information
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. |