QueryTable.CommandText Property

Syntax

expression.CommandText

expression An expression that returns a QueryTable object.

Remarks

For OLE DB sources, the CommandType property describes the value of the CommandText property.

For ODBC sources, setting the CommandText causes the data to be refreshed.

Example

This example sets the command string for the first query table's ODBC data source. Note that the command string is an SQL statement.

Set qtQtrResults = _ Workbooks(1).Worksheets(1).QueryTables(1) With qtQtrResults .CommandType = xlCmdSQL .CommandText = _ "Select ProductID From Products Where ProductID < 10" .Refresh End With

See also:

• QueryTable Object
• QueryTable Object Members