Data Formatting
このセクションでは、本プロバイダーの接続文字列で設定可能なData Formatting プロパティの全リストを提供します。
| プロパティ | 説明 |
| 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 | 値を囲む文字をエスケープする際に使用する文字を指定します。 |
| QuoteCharacter | CSV ファイルで値を囲む際に使用する文字を指定します。 |
| 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 | この設定では、CSV ファイルに書き込まれるdatetime 値のフォーマットを指定します。 |