Database Tour allows you to copy data from active data set to clipboard.

Below, you can find the brief description of how to do that. If need more information and detailed examples, please click here.

Copying Data in Text Format

To copy data to clipboard, use the corresponding button of the main window, Tools | Copy to Clipboard menu, or context menu of the table.

You can select one of several data ranges to copy: full table, current column, current record, or selected records.

After copying, you can paste data into another application (for example, Microsoft Excel) or into the table opened in Database Tour.

The copying function is available not only for tables with data, but also for other tables in the application (for example, tables of fields, indexes, SQL history etc.).

Notes

  1. It is recommended, that the data for copying do not contain tab or carriage return characters because these characters are used in copying procedures to separate columns and records, respectively.
  2. Contents of MEMO and CLOB fields (fields with large text) are copied only if the corresponding option is set.

Copying Data in Specific Format

Using Tools | Copy to Clipboard | Custom... menu or the corresponding menu item below the Copy Data to Clipboard button, you can export data to clipboard instead of file or another database. Here, you have standard Export dialog, with its ability to choose the target format and a lot of specific options.

See also

 Using Clipboard

 Copy Full Dataset to Clipboard

 Copy or Export Data to Clipboard

 Paste Data from Clipboard to Table

 Exporting Data

 Working with Current Row