Export data with the Export Wizard

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

To export result sets data using Interactive SQL
  1. Execute a query.

  2. In Interactive SQL, choose Data » Export.

  3. Follow the instructions in the Export Wizard wizard.

To export result sets data to an UltraLite database 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. Choose Data » Export.

  3. Click In A Database.

  4. In the Database Type list, select UltraLite.

  5. In the User Id field, type dba.

  6. In the Password field, type sql.

  7. Click the Database tab.

  8. In the Database File field, type C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples\UltraLite\CustDB\custdb.udb.

  9. Click Next.

  10. Click In A New Table.

  11. In the Owner field, type dba.

  12. In the Table Name field, type NewTable.

  13. Click Export.

  14. Choose SQL » Previous SQL.

    The IMPORT statement created and used by the Import Wizard appears in the SQL Statements pane:

    --  Generated by the Export Wizard
    OUTPUT USING 'driver=UltraLite 11;UID=dba;PWD=sql;
    DBF=C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples\UltraLite\CustDB\custdb.udb' 
    INTO "dba"."NewTable" 
    CREATE TABLE ON