Key Features: Exporting and Importing Data


In this database tool, you can export data to:

  • New or existing table(s) in the same database.
  • New or existing table(s) in another database of any supported type.
  • Separate file(s). This can be text, CSV or HTML documents, Excel sheets, SQL scripts and some other formats.

There is a large set of export options, which gives you the ability to maximally customize the exporting output and the process itself. Exporting to HTML, PDF and RTF can be performed with pictures and all text formatting (including conditional formatting).

Field mappings for export and import can be saved to file and loaded from file. It is possible to use calculated fields.

Data exporting can also be executed in command line mode (Database Tour Pro only). This allows to use the feature in scheduling and in making calls to Database Tour Pro from other programs, including your own ones.

You can import data from a table in the same or another database. Also, it is possible to import data files like .db, .dbf, .csv etc by dragging them into the table list of the open database. Importing works similarly to exporting, where input and output are swapped; therefore, in all cases where importing destination-db from source-db is needed, it can be replaced with exporting source-db to destination-db.

Exporting Images

Exporting images to HTML

The program can automatically detect the most known image types (JPG, PNG, GIF, BMP, ICO) in BLOB fields of a source database and export them, for example, to HTML or RTF formats. It can also convert image format on the fly.

Exporting to HTML Using Template

Export to HTML using template

Using HTML template allows producing highly customizable output, therefore target HTML file can be used directly in frontend without any further tuning.

Exporting Several Tables to One File

Exporting several tables to one file

In just a few clicks you can easily export several selected tables to one target file. Exporting selected tables as one table per file is also possible.

Exporting with Formatting

Exporting to HTML using current formatting

When exporting a current dataset to HTML, PDF or RTF, it is possible to preserve current formatting (font and background) of the table columns.

Export Dialog

Export dialog (export to HTML)

It is possible to choose the output format and specify many common export options as long as options specific to selected target format.

Exporting to Database

Exporting to database (to SQL Server)

You can export (copy) data not only to many file formats, but also to any relational database, supported by the database engine interface.

Field Mappings

Field mappings (Access to Oracle)

Before exporting data, it is possible to specify source-to-target field mappings. You can use the field names or dynamic expressions here.

Importing data

Import Dialog

The program allows to import data into the current database from another table (including other database) or open query. There are lot of useful import options.

For more details about exporting data, please see Database Tour documentation:

Export Data

Typical Tasks Solutions