Data Export Overview

With dbForge Studio you can easily export data from one or several tables to the following file formats:

  • HTML (Hypertext Markup Language) - a data storage format used for the web pages.
  • Text - plain text format.
  • XLS - Microsoft Excel spreadsheet.
  • XLSX - Microsoft Excel 2007 spreadsheet.
  • Google Spreadsheet.

  • MS Access - database of well-known Microsoft DBMS Access (2003, 2007+).

    Note

    If you do not have Microsoft Office installed, you need to install Open XML SDK 2.5 for Microsoft Office to use the result Microsoft Excel spreadsheet.

  • RTF - Rich Text Format from Microsoft.
  • PDF (Portable Document Format) - file format, created by Adobe Systems for document exchange. (Only Latin charset data can be exported.)
  • JSON - an open-standard format that uses human-readable text to transmit data objects consisting of attribute-value pairs.
  • XML (XML Schema Definition) - XML data representation with data contained in attributes. Contains XML schema.
  • CSV (Comma-separated values)* - another name for the comma-delimited format of data storage.
  • ODBC (Open Database Connectivity)* - a data storage format used to access any data from any application.
  • DBF - a database filename extension (Foxpro, dBase III, dBase IV, dBase 7). Other files can also be connected with DBF files, for example: .DBT (dBase III, IV, Clipper), .FPT (FoxBASE/FoxPro). While exporting data, ANSI charset is used.
  • SQL - format of the file that contains a SQL script.

Note

  • Express Edition of dbForge Studio supports export only to HTML, CSV and ODBC formats.

Note

When using text/csv ODBC provider, on the Export Format page enter a file name with an extension in the Destination table name field, e.g., table.csv.

Note

When exporting data to MS Excel format through ODBC provider, the following export limits exist:

  • for export to MS Excel 2003 format - 65536 records
  • for export to MS Excel 2007 format - 1 048 576 records

Data export to MS Excel (not through ODBC provider) is limited only by available system memory.

dbForge Studio gives a simple way to export data both from Database Explorer and the grid. Using Database Explorer, you can select any table for export in seconds. Also you can compose a complex query, execute it, and then select exported data from the grid.

dbForge Studio includes the Data Export Wizard which allows you to select the following:

  • columns
  • data formats for each column
  • rows
  • additional options for each exported format

Based on your needs, you can save your selected export options into a template file for the further usage in the wizard.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?
Download a free 30-day trial