Home arrow MySQL arrow Using Navicat to Import Data into MySQL

Using Navicat to Import Data into MySQL

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.

  1. Using Navicat to Import Data into MySQL
  2. Using Navicat's Import/Export Wizard
  3. Other Features of Navicat
  4. Conclusion
By: Michael Mak
Rating: starstarstarstarstar / 30
April 19, 2004

print this article



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.

>>> More MySQL Articles          >>> More By Michael Mak

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: