Query Table Object and the Query Tables Collection

The QueryTables collection holds the collection of data tables created from an external data source. Each QueryTable object represents a single table in a worksheet filled with data from an external data source. The external data source can be an ODBC source, an OLE DB source, a text file, a Data Finder, a web-based query, or a DAO/ADO recordset. Possible parents of the QueryTables collection are the Worksheet and ListObject objects.

The QueryTables collection has a few properties and methods not typical of a collection. These atypical attributes are listed next. The QueryTables collection has no properties outside the typical collection attributes listed at the beginning of this appendix.

0 0

Post a comment