Chapter 7. Features and Dialogs
Prev Export Data Next

Export Data

The current result set in the Data Viewer can be exported in this dialog. The export will contain all data even although there are records waiting for fetch: all data are fetched before export starts.

Warning

Data exporting may be resource and time consuming operation. Be patient if you are exporting a large amount of data.

Export Data

Format

Chose one of the supported formats to export.

Export to

File - export data into file on local filesystem.

Clipboard - export data to the clipboard for pasting into another application directly.

File

Path to file if the File method is selected.

Export Headers Too

Column names will be exported too if is this option is enabled. If exporting in SQL inserts format, a CREATE TABLE statement with the column names will be put at the start of the output .

Encoding

Text encoding of the exported data. UTF8 is commonly the best option.

Line End

Specifies text line ending (CR/LF/both) to fit various operating systems.

Supported Formats

  • Comma Separated Values (CSV)

  • HTML table

  • Microsoft Excel XML

    Caution

    MS Excel XML is not the binary XLS document. It is a special type of XML file.

  • Python list. A list structure for Python programming language.

  • SQL inserts, Insert statements in ANSI form.

Prev Export.html Next
Data Viewer  Contents Chapter 8. Questions and Answers