IncludeColumnHeaders
Specifies whether the provider derives column names from the first row of each file.
データ型
bool
デフォルト値
true
解説
When this property is set to true, the 本製品 reads column names from the first row of each file.
When set to false, the 本製品 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.