L.2.11.4.1 QueryTable XML

L.2.2 Sheets

<queryTable xmlns="…" name="Database1.accdb" connectionId="2"
  autoFormatId="16" applyNumberFormats="0" applyBorderFormats="0"
  applyFontFormats="0" applyPatternFormats="0" applyAlignmentFormats="0"
  applyWidthHeightFormats="0">
  <queryTableRefresh nextId="6" unboundColumnsRight="1">
    <queryTableFields count="4">
      <queryTableField id="1" name="ID" tableColumnId="1"/>
      <queryTableField id="2" name="Field1" tableColumnId="2"/>
      <queryTableField id="3" name="Field2" tableColumnId="3"/>
      <queryTableField id="5" dataBound="0" tableColumnId="4"/>
    </queryTableFields>
    <queryTableDeletedFields count="1">
      <deletedField name="Field3"/>
    </queryTableDeletedFields>
  </queryTableRefresh>
</queryTable>

In the context of queryTableRefresh:

In the context of queryTableFields:

Each of the queryTableField elements expresses information about one of the columns in the Table that is part of the QueryTable. For example, the right-most column’s dataBound is set to 0, indicating that this column is not bound to external data.

In the context of queryTable:

Last updated on March 14, 2025

L.2.11.3.1 QueryTable XML L.2.12.1 Overview