Export (0) Print
Expand All

ODBCConnection.SourceData Property

Office 2007
Returns the data source for the ODBC connection, as shown in the table. Read/write Variant.

Version Information
 Version Added:  Excel 2007

Syntax

expression.SourceData

expression   A variable that represents an ODBCConnection object.

Remarks

Data sourceReturn value
Microsoft Excel list or databaseThe cell reference, as text.
External data sourceAn array. Each row consists of an SQL connection string with the remaining elements as the query string, broken down into 255-character segments.
Multiple consolidation rangesA two-dimensional array. Each row consists of a reference and its associated page field items.
Another PivotTable reportOne of the above three kinds of information.

This property is not available for OLE DB data sources.




Community Additions

ADD
Show:
© 2015 Microsoft