Data
This section provides a complete list of the Data properties you can configure in the connection string for this provider.
| Property | Description |
| AllowFormula | Whether or not to treat values starting with an equals (=) sign as formulas during INSERTs and updates. |
| EmptyValueMode | 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. |
| IgnoreCalcError | Indicates whether to ignore errors that occurred during the calculation. |
| NullValueMode | Indicates whether to read empty cells as null or as empty. |
| HasCrossSheetReferences | Indicates how cross sheet references are handled. |
| Recalculate | Indicates whether to recalculate all formulas when data is read. |
| ShowEmptyRows | Indicates whether or not the empty rows should be pushed. |
| TypeDetectionScheme | Determines how the provider detects the data types of columns. |
| EnableOleDbCompatibility | Indicates whether to read the data with the same behavior as the Microsoft OleDB driver. |
| UseFastInsert | Indicates whether to use the fastInsert when executing INSERT Statement. |
| AggregateFiles | Allows URI to be set to a local directory instead of a single file. Aggregates the contents of all identically structured files in the directory to one table per sheet. |
| SkipTop | Skips the number of rows specified starting from the top. |
| IncludeCustomNames | Indicates whether or not the defined names should be pushed. |
| IncludeSubdirectories | Includes the subdirectories of the URI in the aggregation when AggregateFiles is set to true. |
| MetadataDiscoveryURI | Indicates which file is considered the metadata document when the AggregateFiles is set to true. |