XlConnectionType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the type of database connection.

Name

Value

Description

xlConnectionTypeDATAFEED

6

Data Feed

XlConnectionType.xlConnectionTypeMODEL

7

PowerPivot Model

xlConnectionTypeNOSOURCE

No source

xlConnectionTypeODBC

2

ODBC

xlConnectionTypeOLEDB

1

OLEDB

xlConnectionTypeTEXT

4

Text

xlConnectionTypeWEB

5

Web

xlConnectionTypeWORKSHEET

8

Worksheet

xlConnectionTypeXMLMAP

3

XML MAP

Show: