Data Import
If you have to import data to tables of MySQL databases, you can rely upon dbForge
Studio. The MySQL import tool available in it will perform import the way you would
like to. It allows users to import data from eight widely-used formats
and tune the MySQL import process accurately.
In dbForge Studio, MySQL import tool is represented as a well-designed comprehensive
wizard, where each step of the process can be found on a separate page. In addition,
you have a possibility of saving import templates that can be used afterwards to
import data via this very wizard or through the command line.
Data Import Wizard capabilities:
-
Import from 10 widely-used data formats
(Text, MS Excel, MS Excel 2007, Google Sheets, MS Access, XML, CSV, DBF (Foxpro, dBase III, dBase IV, dBase 7), ODBC, JSON)
- Templates to save import settings for each data format
- Import to existing or new tables
- Preview of imported data
- Selecting data formats and column settings for imported data
- Selecting import modes: Append, Update, Append/Update, Delete, Repopulate
- Bulk insert to speed up import
- Setting up errors handling
- Generating a log file with import session details
Find out more about MySQL Data Import feature in our blog:
How To: Import Data to MySQL from Text File
Data Export
Along with the MySQL import tool, dbForge Studio delivers a data export tool as
well. It can export data to ten widely-used formats, and you can adjust the export
process the way you need.
MySQL data export can be performed with the help of a wizard. In the wizard, you
can easily select tables or views to export data from, select columns or a range
of columns for export, and adjust formatting options (for text formats). Also you
can save a template with the needed settings to be used afterwards in the wizard
or through the command line.
MySQL Data Export Wizard offers:
-
Export to 14 widely-used data formats (HTML, Text, MS Excel, MS Excel 2007, Google Sheets, MS Access,
RTF, PDF, XML, CSV, JSON, ODBC, DBF (Foxpro, dBase III, dBase IV, dBase 7), SQL)
- Export from tables, views, or queries
- Templates to save export settings for each data format
- Selecting columns and a range of rows for export
- Setting up fonts and colors for graphical formats
- Selecting formatting for text formats
- Setting up data formats for exported data
- Page setup for RTF, PDF, MS Excel formats
- Unicode support