Identifies a comma-separated list of values to read as null.

Data Type

string

Default Value

""

Remarks

Set this connection property to a comma-separated list of values that you want the driver to regard as null in query results.

For example: if you set this connection property to NaN,\N,N/A, then any cell containing "NaN", "\N", or "N/A" returns a null value.