Schema
This section provides a complete list of the Schema properties you can configure in the connection string for this provider.
| Property | Description |
| Location | Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path. |
| BrowsableSchemas | Optional setting that restricts the schemas reported to a subset of all available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC . |
| Tables | Optional setting that restricts the tables reported to a subset of all available tables. For example, Tables=TableA,TableB,TableC . |
| Views | Optional setting that restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC . |
| Header | Indicates whether or not the provider should detect column names from the first row. |
| IncludePrimaryKey | Controls whether the driver includes an auto-generated primary key column in the table definition. |
| PrimaryKeyIdentifier | Specifies the name of the primary key column that holds the row number. |
| DefineTables | Defines the ranges within a worksheet that will appear as tables. |
| IncludePreRangeColumns | Controls whether to include columns that appear before the specified Excel range. |
| SeparatorCharacter | Specifies the character used to separate the workbook name and worksheet name in the generated table name. |
| IncludeFileExtensions | Specifies whether file extensions should be included in table names. |
| IncludeFilePath | Specifies whether to include the file path in table names. This property has no effect when the provider is using the Search API. |
| SkipFilesLargerThan | The maximum file size (in MB) of workbook files included when scanning for worksheets to model as tables. |