Exporting tables

You can export tables from an Ability Database. The exported tables can be exported to another database in Ability or another program altogether.

To export a table you should first open the Ability database from which the table is to be exported (see Opening a database). Once you are in Database Manager, do the following:

  1. Select Export from the File menu. The "Export" dialog is opened.

  2. In the Data Destination box select the type of database to which you want to export and then click on OK.

  3. In the Objects box all the tables in the current Ability database are listed. Select the table you want to export and click on OK.

  4. The "Save As" dialog is opened. The destination database type is displayed in the Save as type box. Locate the destination database in the Save in box and select it to place it in the File name box.

  5. Click on Save to export the table to the selected destination database.

Open the destination database and the exported table will be shown in the Database Manager (or equivalent, depending on the program). You can now go ahead and work with the exported table as you would with any table created in the destination database.