Access Table Example
This example demonstrates a QueryTable that is applied to a Table object. This data came from connecting to an Access database table with four fields: "ID", "Field1", "Field2", and "Field3". "Field3" has been deleted from the QueryTable in the worksheet below. Notice that a calculated column has been added to the Table, in the column titled "CustomClientColumn", which concatenates the values from "Field1" and "Field2".