Using Navicat to Import Data into MySQL (
Page 1 of 4 )
In today's article Michael takes a look at using Navicat (a MySQL management
tool) to quickly and easily import/export data to and from MySQL.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.
In Depth
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.
Getting Started
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.
/ 28 
