Exporting SQL query results to a CSV file
SQL query results can be shown on a grid. The contents of this grid can be exported to a CSV file (to, for example, load values into an Excel spreadsheet).
To export the contents of the SQL query results grid to a comma separated variable file):
- To select the whole grid, click the square at the top left corner of the grid (underneath the title bar).
- Make sure that the grid is the current window and that it contains valid data.
- Select Edit | Export to file.
- Choose whether or not you want to export the column headings, as well as the data values.
- Enter a name for the CSV file.