Share via


QueryTable.FieldNames Property (Excel)

True if field names from the data source appear as column headings for the returned data. The default value is True. Read/write Boolean.

Syntax

expression .FieldNames

expression A variable that represents a QueryTable object.

Remarks

If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

The FieldNames property applies only to QueryTable objects.

Example

This example sets query table one so that the field names don’t appear in it.

Worksheets(1).QueryTables(1).FieldNames = False

See Also

Concepts

QueryTable Object

QueryTable Object Members