Indicates whether to read the data with the same behavior as the Microsoft OleDB driver.

Syntax

Connect-Excel -EnableOleDbCompatibility SwitchParameter

Data Type

bool

Default Value

false

Remarks

Indicates whether to read the data with the same behavior as the Microsoft OleDB driver.For example, the Microsoft OleDB driver would report the the newline as '\n' instead of '\r\n'.