XlConnectionType enumeration (Excel)
Specifies the type of database connection.
Name | Value | Description |
---|---|---|
xlConnectionTypeDATAFEED | 6 | Data Feed |
xlConnectionTypeMODEL | 7 | PowerPivot Model |
xlConnectionTypeNOSOURCE | 9 | No source |
xlConnectionTypeODBC | 2 | ODBC |
xlConnectionTypeOLEDB | 1 | OLEDB |
xlConnectionTypeTEXT | 4 | Text |
xlConnectionTypeWEB | 5 | Web |
xlConnectionTypeWORKSHEET | 8 | Worksheet |
xlConnectionTypeXMLMAP | 3 | XML MAP |
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.