Data
This section provides a complete list of the Data properties you can configure in the connection string for this provider.
| Property | Description |
| AllowFormula | Specifies whether to treat values starting with an equals (=) sign as formulas during inserts and updates. |
| EmptyValueMode | Specifies whether to read cells containing empty strings as empty or as null. |
| NullValues | Identifies a comma-separated list of values to read as null. |
| IgnoreCalcError | Specifies whether to include spreadsheet calculation error types in query results. |
| NullValueMode | Indicates whether empty cells are read as null or as empty. |
| HasCrossSheetReferences | Specifies how cross-sheet references are handled. |
| Recalculate | Specifies whether to recalculate formula values when cells involved in formula calculation are updated. |
| ShowEmptyRows | Determines whether empty rows are included in query results. |
| TypeDetectionScheme | Determines how the provider detects the data types of columns. |
| EnableOleDbCompatibility | Specifies whether to emulate how the Microsoft OLE DB Driver reports newline characters. |
| UseFastInsert | Indicates whether to use the efficient insert mode, which forces inserts to append new lines to the bottom of the spreadsheet. |
| AggregateFiles | Enables the ability to aggregate the content of identically-named sheets across multiple workbook files. |
| SkipTop | Specifies the number of rows (or columns, when Orientation=Horizontal) immediately after the header to omit from query results. |
| IncludeCustomNames | Indicates whether or not the defined names should be pushed. |
| IncludeSubdirectories | Indicates whether to include workbook files in subdirectories when list. |
| MetadataDiscoveryURI | Identifies the workbook that is used as the source of metadata when aggregating sheets with the AggregateFiles connection property. |
| PathSeparator | The character used to represent path separators when calculating the names of tables based on spreadsheets in nested folders. |