DataFormatting
This section provides a complete list of the DataFormatting properties you can configure in the connection string for this provider.
| Property | Description |
| IncludeColumnHeaders | Whether to get column names from the first line of the specified files. |
| FMT | The format to be used to parse all text files. |
| ExtendedProperties | The Microsoft Jet OLE DB 4.0-compatible extended properties for text files. |
| RowDelimiter | The character that will be used to detect the end of a CSV row. |
| SkipTop | Skips the amount of rows specified starting from the top. |
| IgnoreBlankRows | Indicates whether to skip the empty rows. |
| IncludeEmptyHeaders | Whether to include empty value for a column name within column header. |
| SkipHeaderComments | If set to true, skips rows at the top of the file beginning with #. |
| Charset | Specifies the session character set for encoding and decoding character data transferred to and from the CSV file. The default value is UTF-8. |
| QuoteEscapeCharacter | Determines the character which will be used to escape quotes. |
| QuoteCharacter | Determines the character which will be used to quote values in CSV file. |
| TrimQuotedValues | Enables trimming of spaces in quoted values according to the TrimSpaces property. |
| TrimSpaces | Specifies how leading and trailing spaces in cell values are processed. |
| PushEmptyValuesAsNull | Indicates whether to read the empty values as empty or as null. |
| NullValues | A comma separated list which will be replaced with nulls if there are found in the CSV file. |
| PathSeparator | Determines the character which will be used to replace the file separator. |
| IgnoreIncompleteRows | Determines how incomplete rows are handled. |
| MaxCellLength | Max length a cell can hold, after passing this number the cell content will get truncated. If value is -1 then we don't limit the cell content length. |
| DateTimeFormat | This setting specifies in which format the datetime values will be written to for CSV files. |