XlCmdType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the value of the CommandText property.
public enum class XlCmdType
public enum XlCmdType
Public Enum XlCmdType
- Inheritance
-
XlCmdType
Fields
Name | Value | Description |
---|---|---|
xlCmdCube | 1 | Contains a cube name for an OLAP data source. |
xlCmdSql | 2 | Contains an SQL statement. |
xlCmdTable | 3 | Contains a table name for accessing OLE DB data sources. |
xlCmdDefault | 4 | Contains command text that the OLE DB provider understands. |
xlCmdList | 5 | Contains a pointer to list data. |
xlCmdTableCollection | 6 | Contains the name of a table collection. |
xlCmdExcel | 7 | Contains an Excel formula. |
xlCmdDAX | 8 | Contains a Data Analysis Expressions (DAX) formula. |