ODBCConnection object (Excel)
Represents the ODBC connection.
Remarks
An ODBC connection can be stored in an Excel workbook. When Excel opens the workbook, it creates an in-memory copy of the ODBC connection known as the ODBCConnection object.
An ODBCConnection 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 ODBCConnection 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).
Methods
Properties
- AlwaysUseConnectionFile
- Application
- BackgroundQuery
- CommandText
- CommandType
- Connection
- Creator
- EnableRefresh
- Parent
- RefreshDate
- Refreshing
- RefreshOnFileOpen
- RefreshPeriod
- RobustConnect
- SavePassword
- ServerCredentialsMethod
- ServerSSOApplicationID
- SourceConnectionFile
- SourceData
- SourceDataFile
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for