MYSQL TO CSV CONVERTER
MySQL to CSV files Converter is a tool to Convert, Migrate data from Excel or CSV files to MySQL Database or from MySQL to CSV / Text Files or Fixed width files. You can convert multiple CSV files or Excel sheets in one go to MySQL or convert multiple MySQL tables to CSV files. While converting you can map CSV columns to matching MySQL table columns, You can also filter rows by specifying WHERE conditions.
CSV to MySQL Converter comes with a built in scheduler so that you can run transfer jobs automatically at specified intervals. No need to run jobs repeatedly, just create a session define the schedule interval date and time and CSV to MySQL Converter will automatically executes your session in the background and records the actions in a specified log file.
Excel to MySQL Converter also lets you run migration jobs from Windows command line. It comes with separate Runtime Executable file which can be called from command line or from any other application. Thus providing easy integration with your own application
Supports all versions of MySQL. Doesn’t need any ODBC or third Party drivers.
Using CSV to MySQL Converter you can perform the following conversion
- Excel XLX / XLSX, CSV or Delimited Text files to MySQL Database
- MySQL to CSV or Delimited Text files or Fixed Width files
- Excel XLX / XLSX, CSV or Delimited Text files to MySQL SQL Dump file
- Excel, CSV or Delimited Text Files to CSV / Delimited / Fixed Width files
- MySQL to MySQL Database
- MySQL to MySQL SQL Dump file
Top Features
Supported Databases
- MySQL
- MySQL Dump
- Oracle
- Oracle SQL Dump
- MS Access
- PostgreSQL
- Foxpro/DBF Files
- CSV/Text or Fixed width
- MS SQL Server
- MS SQL Server Dump
- Maria DB
- Amazon RDS
- Amazon Aurora
- Google Cloud
- Azure Database for MySQL
Constraints and Indexes
Imports all Constraints and Indexes and Auto Increment attributes.
In Built Scheduler
Automatically transfer data without any interaction.
Bulk Loading
Bulk Loading feature for Oracle, MySQL and MS SQL Server databases to load millions of rows at blazing speed.
Column Mapping
Load into new or existing tables with full Column Mapping.
SQL DUMP FILES
Generate SQL dump files from any database source.
Synchronize
UPSERT and INSERT loading options to Synchronize Source and Target databases.
Select the Folder containing Excel/CSV files, Choose Target MySQL database and click Start