Export Data

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

Warning

Data exporting may be resource and time consuming operation. Be patient if you are exporting 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 computer memory for pasting in the others applications directly.

File

Path to file if is the File method selected.

Export Headers Too

Column names will be exported too if is this option enabled.

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 operation systems implementations.

Supported Formats

  • Comma Separated Values (CSV)

  • HTML table

  • Microsoft Excel XML

    Caution

    MS Excel XML is not 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.