XlCmdType Enumeration

Excel Developer Reference

Specifies the value of the CommandText property.

Name Value Description
xlCmdCube 1 Contains a cube name for an OLAP data source.
xlCmdDefault 4 Contains command text that the OLE DB provider understands.
xlCmdList 5 Contains a pointer to list data.
xlCmdSql 2 Contains an SQL statement.
xlCmdTable 3 Contains a table name for accessing OLE DB data sources.