Home arrow MySQL arrow Page 2 - Importing Data into MySQL with Navicat
MYSQL

Importing Data into MySQL with Navicat


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.

Author Info:
By: Michael Mak
Rating: 4 stars4 stars4 stars4 stars4 stars / 28
September 13, 2003
TABLE OF CONTENTS:
  1. · Importing Data into MySQL with Navicat
  2. · Overview
  3. · Using Navicat's Import/Export Wizard
  4. · Other Features of Navicat
  5. · Conclusion

print this article
SEARCH DEVARTICLES

Importing Data into MySQL with Navicat - Overview
(Page 2 of 5 )

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.


blog comments powered by Disqus
MYSQL ARTICLES

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 – More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials