Share via


QueryTable.SourceConnectionFile Property

Excel Developer Reference

Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the QueryTable. Read/write.

Syntax

expression.SourceConnectionFile

expression   A variable that represents a QueryTable object.

Remarks

Data from Web queries or text queries is imported as a QueryTable object, while all other external data is imported as a ListObject object. You can use the QueryTable property of the ListObject to access the SourceConnectionFile property.

If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

You can use the QueryTable property of the ListObject to access the SourceConnectionFile property.

See Also