Specifies Microsoft Jet OLE DB 4.0-compatible extended properties that define the format of local text files.

Syntax

Connect-CSV -ExtendedProperties string

Data Type

cstr

Default Value

""

Remarks

This property allows you to specify the text file format using Microsoft Jet OLE DB 4.0-style extended properties. When processing local files, any format defined in a Schema.ini file overrides this setting. Likewise, IncludeColumnHeaders and FMT are overridden by ExtendedProperties.

The following example parses all text files in the target folder as tab-delimited values with headers:

ExtendedProperties='text;FMT=TabDelimited'

The next example parses .csv and .log files as CSV without headers:

ExtendedProperties='text;IncludeColumnHeaders=False';Include Files='CSV,LOG'

This property is useful for maintaining compatibility with Microsoft Jet OLE DB 4.0 configurations or when importing files that follow a specific legacy text format.