Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Exporting data from databases » Export tools

Export tools Next Page

Using the Interactive SQL Export wizard

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.

Example

The following example shows you how to export a result set from a SQL query to a file.

To export result sets data using Interactive SQL

  1. 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.

  2. In Interactive SQL, choose Export from the Data menu.

    The Export dialog appears.

  3. Specify a name and location for the exported data.

  4. Specify the file format and then click OK.

    The result set is exported to a file in the location that you specified.