Share via


QueryTable.SourceDataFile Property

Excel Developer Reference

Returns or sets a String value that indicates the source data file for a query table.

Syntax

expression.SourceDataFile

expression   A variable that represents a QueryTable object.

Remarks

For file-based data sources (e.g. Access), the SourceDataFile property contains a fully qualified path to the source data file. It is set to Null for server-based data sources (e.g. SQL Server). The SourceDataFile property is set to Null if the Connection property is changed programmatically.

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 SourceDataFile property.

See Also