Export Data

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 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 is the File method 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 name will be put at the start of the output.

Encoding

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

Line End

Allow to change text line ending (CR/LF) to fit various operating systems implementations.

Supported Formats

  • Comma Separated Values (CSV)

  • HTML table

  • Microsoft Excel XML

    Caution

    MS Excel XML is not the binary XLS document. It's special case of XML file.

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

  • SQL inserts, Insert statements in ANSI form.