_QueryTable.SourceDataFile Property
Returns or sets a String indicating the source data file for a query table.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property SourceDataFile As String
Get
Set
'Usage
Dim instance As _QueryTable
Dim value As String
value = instance.SourceDataFile
instance.SourceDataFile = value
string SourceDataFile { get; set; }
Property Value
Type: System.String
Remarks
For file-based data sources (e.g. Access) the SourceDataFile property contains a fully qualified path to the source data file. It is null for server-based data sources (e.g. SQL Server). The SourceDataFile property is set to null if the Connection property is changed programmatically.