Data Formatting
This section provides a complete list of the Data Formatting properties you can configure in the connection string for this provider.
| Property | Description |
| IncludeColumnHeaders | Specifies whether the provider derives column names from the first row of each file. |
| FMT | Specifies the file format that the provider uses to parse all text files. |
| ExtendedProperties | Specifies Microsoft Jet OLE DB 4.0-compatible extended properties that define the format of local text files. |
| RowDelimiter | Specifies the character or sequence of characters that the provider uses to detect the end of a row in a text file. |
| SkipTop | Specifies the number of rows that the provider skips from the top of the file before reading data. |
| IgnoreBlankRows | Specifies whether the provider skips blank rows when reading data from text files. |
| IncludeEmptyHeaders | Specifies whether the provider includes columns with empty header values when reading files that contain column headers. |
| SkipHeaderComments | Specifies whether the provider skips comment rows at the top of a file. |
| Charset | Specifies the character set that the provider uses to encode and decode text data when reading from or writing to files. |
| 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 | Specifies whether the provider trims spaces inside quoted values when applying the TrimSpaces property. |
| TrimSpaces | Specifies how the provider handles leading and trailing spaces in cell values. |
| PushEmptyValuesAsNull | Specifies whether the provider converts empty values to null when reading data. |
| NullValues | A comma separated list which is replaced with nulls if there are found in the CSV file. |
| PathSeparator | Specifies the character that the provider uses to replace file path separators when generating table names. |
| IgnoreIncompleteRows | Specifies how the provider handles rows that do not match the expected structure based on the column headers. |
| MaxCellLength | Specifies the maximum number of characters that a cell can contain before its value is truncated. |
| DateTimeFormat | This setting specifies in which format the datetime values will be written to for CSV files. |