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

Data Type

string

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.