TypeDetectionScheme
Determines how the provider detects the data types of columns.
Possible Values
None, RowScan, ColumnFormat, ColumnStyleData Type
string
Default Value
"ColumnFormat"
Remarks
Set this connection property to one of the following:
| None | Returns all columns as string type. |
| RowScan | Scans rows to determine the data type. The RowScanDepth determines the number of rows that the server scans when determining the data type. |
| ColumnFormat | Reports the data type based on the cell format (Number, Currency, Date, etc.) of the column. |
| ColumnStyle | Scans rows to determine the data type. The RowScanDepth determines the number of rows to be scanned. This retrieves more specific data types (date / time instead of just timestamp), but is more likely to cause values to be truncated due to values in the cells not completely following the associated conventions for those types. |