Exporting data to other formats
Open the Data Export wizard by doing either of these actions:
- In Database Explorer, right-click a table or a view (or CTRL+click several tables and/or views) you want to export data from and select Export Data on the shortcut menu.
- Right-click the data grid and choose Export Data on the shortcut menu
- On the Data Editor window toolbar, click Export Data
- On the Database menu, click Export Data
The appearance of the Data Export Wizard can differ depending on a product you use.
- In the Export format wizard tab, select an export format or load export options from a template file if you saved them previously and click Next.
In the Source wizard tab, select a required MySQL server connection, a database, table(s), view(s), which you want to export, and then click Next.
If you opened the wizard from the data grid, the Source tab would allow you to specify only a name and a path of the destination file (the one where the exported data will be saved.
- In the Options wizard tab, set additional settings for the selected export format and click Next.
- In the Data formats wizard tab, select the exported columns and click Next. (For CSV, HTML, PDF, RTF, and Text export formats, select formats of data representation, for example, integer, date, time, etc. For Excel and Excel 2007 formats, the field is editable only for binary columns and includes only two data types (HexString and String) in the drop-down list).
- In the Exported rows wizard tab, select the exported rows. You can export all rows, only selected in the grid ones, or a specified range.
- Specify how the application should behave when an error is encountered.
- (Optional) To export options to a template file for future usage, click Save Template and specify a path and a name of the template file.
- Define how dbForge Query Builder for MySQL should handle errors during export and whether to write a log file.
- Click Export and see the result of export process.
- Select whether to open the exported file or result folder, and click Finish. Data export is finished.
There is a filter in the Data Export wizard window.
If you want to filter data, use the required column filter. To do this:
- In an SQL document, write a whole data query using the SELECT * FROM statement.
- To implement the query, on the SQL toolbar, click Execute.
- On the column name you need, click the filter icon.
- In the drop-down list, choose the item to filter by.
- Right-click the filtered grid and select Export Data to call the Data Export wizard.
Another and the most reliable way to export filtered data is to filter it directly in the query. To do this, execute the SELECT * FROM statement with the WHERE condition, where you can specify the required filter. And then implement already filtered data export with the Data Export wizard, calling it from the filtered grid shortcut menu.
Follow the Data Export wizard steps, click Export. If the data export is finished successfully, the Data export complete message appears.