Data
This section provides a complete list of the Data properties you can configure in the connection settings 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. |