You can use the Interactive SQL Export wizard to export query results.
Use this export tool when you want to save result sets to a file. In Interactive SQL, from the Data menu, choose Export. This allows you to choose the file format of the exported query results.
The following example shows you how to export a result set from a SQL query to a file.
Execute the following query while connected to the SQL Anywhere sample database.
SELECT * FROM Employees WHERE State = 'GA';
The result set includes a list of all employees who live in Georgia.
In Interactive SQL, choose Export from the Data menu.
The Export dialog appears.
Specify a name and location for the exported data.
Specify the file format and then click OK.
The result set is exported to a file in the location that you specified.