QueryTable QueryTable QueryTable Interface


Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.

public interface class QueryTable : Microsoft::Office::Interop::Excel::_QueryTable, Microsoft::Office::Interop::Excel::RefreshEvents_Event
public interface QueryTable : Microsoft.Office.Interop.Excel._QueryTable, Microsoft.Office.Interop.Excel.RefreshEvents_Event
Public Interface QueryTable
Implements _QueryTable, RefreshEvents_Event


This is a .NET interface derived from a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this derived interface to access all method, property, and event members of the COM object. However, if a method or event you want to use shares the same name under the same COM object, cast to the corresponding primary interface to call the method, and cast to the latest events interface to connect to the event. Refer to this topic for information about the COM object. For information about the method and property members of the COM object, see _QueryTable.

Use QueryTables(index), where index is the index number of the query table, to return a single QueryTable object.

Applies to