Identifies the workbook that is used as the source of metadata when aggregating sheets with the AggregateFiles connection property.

Data Type

string

Default Value

""

Remarks

When the AggregateFiles connection property is enabled, the driver aggregates the content of identically-named sheets from multiple workbook files into consolidated tables called aggregate sheet tables.

To facilitate aggregation of identically-named sheets, a metadata source workbook must be selected. The driver models each sheet from this workbook as an aggregate sheet table named after that sheet.

You can use this connection property to explicitly designate a workbook file as the metadata source workbook. If this connection properly is not set, the first workbook file in the directory is used as the metadata source workbook.