Navicat : Import Data into MySQL

[Martien]

Hello, Everyone. I had just started to work on the MySQL databases. But I am not familiar with the MySQL databases. I could find it difficult to work on the MySQL. Here I want to know about the how could I import the data into the MySQL using the one of the well known software tool that is Navicat. So if anyone knows about the Navicat tool and Can anyone provide me the solution to help me out? Please reply!!!

[Eric B]

Hi, I often need to import various data into MySQL databases. This job becomes a very tedious and tough if we don't have any reliable & easy-to-use MySQL Graphical User Interface. Navicat is one of the most easy and reliable tool that helps you to import the data into the MySQL. This tool Navicat can convert the Excel spreadsheets or Microsoft Access data into MySQL databases by eliminating the time-consuming data entry and the errors that are accomplished it. Have a nice day!

[Glenny]

I think it is better for you that your are using the Navicat. Navicat uses a interface like Microsoft Access and It comes with a MySQL server launcher and It also has comprehensive manual that will help you to get started. This is just a simple MySQL admin client. It's other useful features include that data transfer, scheduled backup, support for Foreign Keys, import/export wizard, visual report builder and visual query builder. It's Database Transfer Tool is a GUI data transfer tool specially designed for the developers who can work between two different MySQL servers. Thanks!

[JonathanD]

I suggest you to try the following steps to import the data into MySQL databases through Navicat:
1. You have to install the Navicat from the CD on your computer.
2. Then You connect to the MySQL host where you want to import your data into. It is quite easy you have to only give your server details and you will be connected.
3. After connecting to the server, In left side of the navicat main window you should see your database :
4. Then click on the database icon and Navicat shows you the list of tables in database.
5. Select the table that you want to Import.
6. Click on Import Wizard button. Import Wizard will gets start.
7. Then Follow the steps of the Import Wizard.
After performing all the above steps you able to import your MS Excel or Access or XML file into your specified MySQL database.
Enjoy!

[Macarenas]

Navicats has the following key features :-
1. It Manages the privileges of user.
2. It can create a reports with the report builder and they can be saved as an .raf file for backup.
3. It allows you take Backup and to restore your database. It also allows you to schedule the backup of your data through the new Schedule Backup feature.
4. It can browse the databases, modifies your data, creates or deletes the databases, tables, indexes and users accounts.
5. It supports multiple connections.
6. It create and run SQL queries with the query builder.
7. It import/export data of 18 formats including MS Access, MS Excel, XML, PDF and TXT.
8. It supports Data Transfer one MySQL server to another MySQL server.