Data Manipulation

Table data and query results are displayed on the Data or Results tab of the Table Editor, SQL Editor or Visual Query Builder.

The data can be displayed in three modes: Grid View, Form View and Print View. See Data Frame to learn more about these modes.

The toolbars of these tabs as well as the popup menus (activated by a right-click on the grid) provide the following functions for managing data:

Export Data
Exports data to 14 available formats, including MS Excel, MS Access, RTF, HTML, PDF and others.

Export Data As INSERT
Exports data to the SQL script as a number of INSERT statements.

Import Data
Imports data from MS Excel, MS Access, DBF, TXT, and CSV.

Edit BLOB
Allows you to view and edit the content of BLOB and TEXT fields.