OLEDBConnection.SourceDataFile Property (Excel)

Returns or sets a String indicating the source data file for an OLE DB connection. Read/write.

Version Information

Version Added: Excel 2007

Syntax

expression .SourceDataFile

expression A variable that represents an OLEDBConnection object.

Remarks

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

See Also

Concepts

OLEDBConnection Object

OLEDBConnection Object Members