Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » Data export


Exporting data with the Export Wizard

Use the Export Wizard in Interactive SQL to export query results in a specific format to a file or database.


You must be the owner of the table you are querying, have SELECT privilege on the table, or have the SELECT ANY TABLE system privilege.

  1. Execute a query.

  2. In Interactive SQL, click Data » Export.

  3. Follow the instructions in the Export Wizard.


The query results are exported to the specified file or database.


  1. Execute the following query while connected to the sample database. You must have SELECT privilege on the table Employees or the SELECT ANY TABLE system privilege.

    SELECT * FROM Employees WHERE State = 'GA';
  2. The result set includes a list of all the employees who live in Georgia.

  3. Click Data » Export.

  4. Click In a database and then click Next.

  5. In the Database type list, click UltraLite.

  6. In the User Id field, type DBA.

  7. In the Password field, type sql.

  8. In the Database file field, type C:\Users\Public\Documents\SQL Anywhere 16\Samples\UltraLite\CustDB\custdb.udb.

  9. Click Next.

  10. Click Create a new table.

  11. In the Table name field, type GAEmployees.

  12. Click Export.

  13. Click Close.

  14. Click SQL » Previous SQL.

    The OUTPUT USING statement created and used by the Export Wizard appears in the SQL Statements pane:

    --  Generated by the Export Wizard
    output using 'driver=UltraLite 16;UID=DBA;PWD=***;
    DBF=C:\\Users\\Public\\Documents\\SQL Anywhere 16\\Samples\\Ultralite\\custdb\\custdb.udb' 
        into "GAEmployees" 
        create table on