CSV to MySQL Conversion

CSV to MySQL Loader is a tool to Convert, Migrate data from CSV Files to MySQL Database or from MySQL to CSV Files. You can convert multiple files in one go to MySQL or convert multiple MySQL tables to CSV files. While converting you can map source columns to matching destination table columns, filter rows by specifying WHERE conditions.

CSV to MySQL Loader comes with a built in scheduler so that you can run transfer jobs at specified intervals. Now no need to run jobs repeatedly, just create a session define the schedule date and time and CSV to MySQL Loader will automatically executes your session in the background and records the actions in a specified log file. You can later on check the log file for information.

Provides a command line interface also to run migration jobs manually so that it can be easily integrated with your own application.

All the sessions are stored in a repository. CSV to MySQL Loader provides a user friendly interface to manage repository. Such as taking backup and/or restore repository from a previous backup. You can also create a new blank repository in case you need it.

Features

Wizard based
Map Source Columns to Target Table columns
Specify WHERE conditions to filter data
Save and Schedule of Sessions for recurring data transfers.
Fast Speed
Completely user friendly
No need to write any code
Repository Database is introduced.
Select single or multiple tables to transfer
Select or Deselect Columns while transferring
Change Destination Datatypes and widths
Automatic Checking of Datatype mismatch
Rated Best in the category by many websites
Most Popular product in Database App. section in download.com
Economical costs just $99 For Standard Version
Fully functional Trial version with just 50 rows limit is available
Transfer Millions of rows easily and fast. That's what our existing Customers are doing
Supports Long , Picture Data types. In a jiffy you can copy data without any coding
Supported O/s: Win 2003,Win 2000, XP, Win ME,Win98 & Win95

What is CSV?

CSV stands for Comma Separated Values, it is a very simple and common standard for tabular data.

CSV is supported by a number of popular tools from spreadsheets like Excel, OpenOffice and Google Docs to complex databases to almost all programming languages. As such it is probably the most widely supported structured data format in the world.

Example of CSV

As CSV file is a plain text file, you can open it in any text editor. Upon opening in a text editor you will notice something like this

101,"Smith Jones",4000
102,"Karren",2300
104,"John, Kenny",8000

Limitations of CSV

NO DATATYPES
CSV lacks any way to specify type information: that is, there is no way to distinguish "1" the string from 1 the number. This shortcoming can be addressed by adding some form of simple schema.
NO RELATIONSHIP
No support for relationships between different "tables".
TABULAR DATA
CSV is really only for tabular data -- it is not so good for data with nesting or where structure is not especially tabular.

Using our tool you can easily load the data from any CSV file to MySQL or other databases. You just need to select the CSV files and then our tool will do the rest.