Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

_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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[GuidAttribute("00024428-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface _QueryTable

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

Show:
© 2016 Microsoft