CommandType Element (Microsoft Excel)

Contains the type of command specified.

Contained In

QuerySource

Remarks

Specified only if the data source is an OLE DB provider, the CommandType element can contain one of the following string constants: Cube, Default, None, SQL, or Table. Specifying Default implies that the command text uses the default syntax of the provider. If this element is not specified, the default value is None.

The command text is specified in the CommandText element.

Example

See the example in the QueryTable element topic.