Exporting query results

You can export query results data to a database or to a file.

About this task

You use the Export Query Results wizard to export query results.

To export query results:

Procedure

  1. Open the Export Query Results wizard in one of the following ways:
    • With a set of query results in available editor, select Results > Export.
    • Select File > Export. Select Result set from the list of available export wizards.
  2. The Export Query Results wizard opens with the Export query results page.

    If you opened the Export Query Results wizard using Results > Export, the name of the active query results that you will export is listed in the Source field.

    If you opened the Export Query Results wizard using File > Export, then you must select the set of query results that you will export from the Source field.

    Note: If the query that you are exporting includes several result sets, all of them are displayed in the Source field.
  3. Select where you want to export the query result data by choosing one of the following:
    • Click File system to export the query results data to a file. The fields that are required to export query results to a file system are displayed.
    • Click Database to export the query results data to a database. The fields that are required to export query results to a database are displayed.