With Query Builder for MySQL, you can easily export data from one or several tables to the following file formats:
MS Access - database of well-known Microsoft DBMS Access (2003, 2007+).
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.
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’.
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.
Query Builder for MySQL provides 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.
Query Builder for MySQL includes Data Export Wizard which allows you to select the following:
Based on your needs, you can save your selected export options into a template file for the further usage in the wizard.