Edit - Export Results

The Export Results command appears when a results table from a query in a command window has the focus.   It enables saving all records in the results table into a variety of popular file formats used for tables.  

 

To save only some of the records in the results table, select them and then choose Edit - Export Selection in the main menu.

 

To export all records from a results table:

 

  1. Run the query in the command window to generate a results table.
  2. With the focus on the command window, choose Edit - Export Results in the main menu.
  3. In the Export dialog, enter a File name for the exported data.
  4. In the Save as type box, choose the desired format.
  5. Press Export to export, or Cancel to abandon the export.

 

Available formats for export:

 

CSV

DBF

GDB

GPKG

HTML

JSON

LAS or LAZ

MDB

MML

SQLite

XLS

 

Exporting to LAS or LAZ requires that all fields required by a LAS or LAZ file are present.

 

Formats serviced by Microsoft code such as HTML, MDB, and XLS will be affected by the presence or absence of the required Microsoft components.   See the discussion in the Microsoft Office Formats - MDB, XLS and Friends topic.   To avoid such issues, when exporting for use in Excel, simply export in CSV, which Excel can read with no issues.

Notes

Index required for selection - Records in a results table can be selected If the results table contains a field with an index, like the mfd_id field, that would make a table selectable and editable.  If the query that generates the result table does not result in a such a field being added to the results table, then records in the results table will not be selectable.

 

See Also

Selection

 

Maps

 

Drawings

 

Images

 

Queries

 

Layers Pane

 

Edit - Export Selection