Specifies whether the provider derives column names from the first row of each file.

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the connector reads column names from the first row of each file.

When set to false, the connector assigns generic column names based on column numbers, unless a Schema.ini file defines explicit column names.

As with Microsoft Jet OLE DB 4.0, this property can also be specified in ExtendedProperties. The IncludeColumnHeaders value specified in ExtendedProperties overrides this property.

The following connection string parses .csv and .log files as CSV without headers:

DataSource=C:\mycsvlogs;IncludeColumnHeaders=False;Include Files='CSV,LOG'

This property is useful for defining whether column names should be inferred from file headers or automatically generated.