Specifies the type of database connection.

Version Information
Version Added: Excel

Name Value Description
xlConnectionTypeODBC 2 ODBC
xlConnectionTypeOLEDB 1 OLEDB
xlConnectionTypeTEXT 4 Text
xlConnectionTypeWEB 5 Web
xlConnectionTypeXMLMAP 3 XML MAP