ADO.NET Provider for CSV

Build 20.0.7654

HDR

Whether to get column names from the first line of the specified files.

Data Type

string

Default Value

"Yes"

Remarks

When this property is set to YES, the provider will derive column names for each table from the first row of each file. When this property is set to NO, column names are simply the column numbers; that is, if column names have not been defined in Schema.ini.

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

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

DataSource=C:\mycsvlogs;HDR=No;Include Files='CSV,LOG'

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654