OLEDBConnection Interface

Represents the OLE DB connection.

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

Syntax

'Declaration
<GuidAttribute("0002448D-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface OLEDBConnection
'Usage
Dim instance As OLEDBConnection
[GuidAttribute("0002448D-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface OLEDBConnection

Remarks

An OLE DB connection can be stored in an Excel workbook. When Micrososft Excel opens the workbook, Excel creates an in-memory copy of the OLE DB connection known as the OLEDBConnection object.

An OLEDBConnection object contains information related to the connection, such as the name of the server to connect to and the name of the objects to be opened on that server. Optionally, the OLEDBConnection object may also include authentication credential information, or a command that is to be passed to the server and executed (for example, a SELECT statement to be executed by SQL Server).

See Also

Reference

OLEDBConnection Members

Microsoft.Office.Interop.Excel Namespace