DataType Property

         Example         Applies To

PivotField object: Returns a constant describing the type of data in the PivotTable field. Can be one of the following XlPivotFieldDataType constants: xlText, xlNumber, or xlDate. Read-only Long.

Parameter object: Returns or sets the data type of the specified query parameter. Read/write Long.

Can be one of the following XlParameterDataType constants:

xlParamTypeBigInt

xlParamTypeBinary

xlParamTypeBit

xlParamTypeChar

xlParamTypeDate

xlParamTypeDecimal

xlParamTypeDouble

xlParamTypeFloat

xlParamTypeInteger

xlParamTypeLongVarBinary

xlParamTypeWChar

xlParamTypeLongVarChar

xlParamTypeNumeric

xlParamTypeReal

xlParamTypeSmallInt

xlParamTypeTime

xlParamTypeTimeStamp

xlParamTypeTinyInt

xlParamTypeUnknown

xlParamTypeVarBinary

xlParamTypeVarChar