Controls whether SharePoint calculated columns are assigned a SQL data type corresponding to the result type of their formula.

Data Type

bool

Default Value

false

Remarks

When set to True, the driver automatically determines the data type of each calculated column by reading the result type of its formula (such as Number, Currency, DateTime, or Yes/No) and mapping that result type to the closest native SQL type.

When set to False (default), all calculated columns are treated as strings, regardless of the result type of their formula.