XlParameterDataType Enumeration
| Excel Developer Reference |
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. |