This topic has not yet been rated - Rate this topic

ODBCConnection.SourceData Property

Office 2010

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Object SourceData { get; set; }

Data source	Return value
Microsoft Excel list or database	The cell reference, as text.
External data source	An 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 ranges	A two-dimensional array. Each row consists of a reference and its associated page field items.
Another PivotTable report	One of the above three kinds of information.

This property is not available for OLE DB data sources.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions