Partager via


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)

Syntax

'Declaration
<GuidAttribute("00024428-0000-0000-C000-000000000046")> _
Public Interface QueryTable _
    Inherits _QueryTable, RefreshEvents_Event
'Usage
Dim instance As QueryTable
[GuidAttribute("00024428-0000-0000-C000-000000000046")]
public interface QueryTable : _QueryTable, 
    RefreshEvents_Event

Remarks

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

See Also

Reference

QueryTable Members

Microsoft.Office.Interop.Excel Namespace