This article discusses a solution to import MS Excel, MS Access and XML data into local or remote MySQL databases using Navicat – a MySQL management tool. You can find out more about Navicat at http://www.mysqlstudio.com/detail.php3.
We very often need to import various data into MySQL databases. This becomes a tough job if we don't have a reliable & easy-to-use MySQL GUI; At times, when I am working on deadlines, this job becomes frustrating and I find myself wishing I had a tool to do this job for me.
Navicat can convert Excel spreadsheets/MS Access data to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. It uses a Microsoft Access-like interface and comes with a MySQL server launcher and comprehensive manual that will help you get started. Navicat is more than just a simple MySQL admin client - other useful features include scheduled backup, data transfer, import/export wizard, support for Foreign Keys, visual query builder, and visual report builder.
Navicat's Database Transfer Tool is a visual data transfer tool designed for developers who work between different MySQL servers or need to move databases between two MySQL servers.
PremiumSoft Navicat enables you to convert your documents (different file types ) into your MySQL databases. Its easy-to-use interface makes it easy to perform the Import/Export action. In Navicat version 5.3, you can save the process as a profile. You can then schedule the execution of this profile.
First of all, you need to install PremiumSoft Navicat. You can download it from http://www.mysqlstudio.com/shareware.php3 . You can connect to the MySQL host where you want to import your data into. This is quite easy as you only have to give your server details and you will be connected.
After connecting, you should see your database in left side of the Navicat main window:
If you click on the database icon, Navicat shows you a list of all tables in that database. Select the table that you want to perform Import action on.
Click on Import Wizard button. The Import Wizard will start. Follow the steps of the Import Wizard and you will be able to import your MS Excel/Access/XML file into your MySQL database.