OLEDBConnection OLEDBConnection OLEDBConnection Interface


Represents the OLE DB connection.

public interface class OLEDBConnection
public interface OLEDBConnection
Public Interface OLEDBConnection


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).


ADOConnection ADOConnection ADOConnection

Returns an ADO connection object if the PivotTable cache is connected to an OLE DB data source. Read-only.

AlwaysUseConnectionFile AlwaysUseConnectionFile AlwaysUseConnectionFile

Trueif the connection file is always used to establish connection to the data source. Read/write Boolean.

Application Application Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

BackgroundQuery BackgroundQuery BackgroundQuery

True if queries for the OLE DB connection are performed asynchronously (in the background). Read/write Boolean.

CalculatedMembers CalculatedMembers CalculatedMembers

Gets the CalculatedMembers collection for the specified connection.

CommandText CommandText CommandText

Returns or sets the command string for the specified data source. Read/write Object.

CommandType CommandType CommandType

Returns or sets one of the XlCmdType constants. Read/write XlCmdType.

Connection Connection Connection

Returns or sets a string that contains OLE DB settings that enable Microsoft Excel to connect to an OLE DB data source. Read/write Object.

Creator Creator Creator

Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. Read-only.

EnableRefresh EnableRefresh EnableRefresh

True if the connection can be refreshed by the user. The default value is True. Read/write Boolean.

IsConnected IsConnected IsConnected

Returns True if the MaintainConnection property isTrue. Returns False if it is not currently connected to its source. Read-only Boolean.

LocalConnection LocalConnection LocalConnection

Returns or sets the connection string to an offline cube file. Read/write Object.

LocaleID LocaleID LocaleID

Gets or sets the locale identifier for the specified connection.

MaintainConnection MaintainConnection MaintainConnection

Returns True if the connection to the specified data source is maintained after the refresh operation and until the workbook is closed. Read/write Boolean.

MaxDrillthroughRecords MaxDrillthroughRecords MaxDrillthroughRecords

Returns or sets the maximum number of records to retrieve. Read/write Integer.


Returns True if the OLE DB connection is connected to an Online Analytical Processing (OLAP) server. Read-only Boolean.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

RefreshDate RefreshDate RefreshDate

Returns the date on which the OLE DB connection was last refreshed. Read-only DateTime.

Refreshing Refreshing Refreshing

True if a background OLE DB query is in progress for the specified OLE DB connection. Read/write Boolean.

RefreshOnFileOpen RefreshOnFileOpen RefreshOnFileOpen

True if the connection is automatically updated each time the workbook is opened. The default value is False. Read/write Boolean.

RefreshPeriod RefreshPeriod RefreshPeriod

Returns or sets the number of minutes between refreshes. Read/write Integer.

RetrieveInOfficeUILang RetrieveInOfficeUILang RetrieveInOfficeUILang

True if the data and errors are to be retrieved in the Office user interface display language when available. Read/write Boolean.

RobustConnect RobustConnect RobustConnect

Returns or sets how OLE DB connection connects to its data source. Read/write XlRobustConnect.

SavePassword SavePassword SavePassword

True if password information in an OLE DB connection string is saved in the connection string. False if the password is removed. Read/write Boolean.

ServerCredentialsMethod ServerCredentialsMethod ServerCredentialsMethod

Returns or sets the type of credentials that should be used for server authentication. Read/write XlCredentialsMethod.

ServerFillColor ServerFillColor ServerFillColor

True if the fill color format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.

ServerFontStyle ServerFontStyle ServerFontStyle

True if the font style format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.

ServerNumberFormat ServerNumberFormat ServerNumberFormat

True if the number format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.

ServerSSOApplicationID ServerSSOApplicationID ServerSSOApplicationID

Returns or sets a single sign-on application (SSO) identifier that is used to perform a lookup in the SSO database for credentials. Read/write String.

ServerTextColor ServerTextColor ServerTextColor

True if the text color format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.

SourceConnectionFile SourceConnectionFile SourceConnectionFile

Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the connection. Read/write.

SourceDataFile SourceDataFile SourceDataFile

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

UseLocalConnection UseLocalConnection UseLocalConnection

True if the LocalConnection property is used to specify the string that enables Microsoft Excel to connect to a data source. False if the connection string specified by the Connection property is used. Read/write Boolean.


CancelRefresh() CancelRefresh() CancelRefresh()

Cancels all refresh operations in progress for the specified OLE DB connection.

MakeConnection() MakeConnection() MakeConnection()

Establishes a connection for the specified OLE DB connection.

Reconnect() Reconnect() Reconnect()

Drops and then reconnects the specified connection.

Refresh() Refresh() Refresh()

Refreshes an OLE DB connection.

SaveAsODC(String, Object, Object) SaveAsODC(String, Object, Object) SaveAsODC(String, Object, Object)

Saves the OLE DB connection as an Microsoft Office Data Connection file.

Applies to