Specifies whether to emulate how the Microsoft OLE DB Driver reports newline characters.

Syntax

Connect-Excel -EnableOleDbCompatibility SwitchParameter

Data Type

bool

Default Value

false

Remarks

If this connection property is set to True, the cmdlet reports newline characters as '\n' instead of '\r\n', as the Microsoft OLE DB Driver does.

If this connection property is set to False, the cmdlet reports newline characters as '\r\n'.