PHPBuilder - Importing Excel, Access or XML Data into MySQL Using Navicat



RSS Twitter
Articles Databases

Importing Excel, Access or XML Data into MySQL Using Navicat

by: PHP Builder Staff
|
December 29, 2003

by kenlin
This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a famous MySQL Admin Tool called Navicat. You can find the information of Navicat at http://www.mysqlstudio.com/detail.php3.

Overview

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 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 to get started. It is more than just a simple MySQL admin client, other useful major features include schedule backup, data transfer, import/export wizard, support 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 5.3 version, you can save the process as a profile. With the profile, you can create a schedule for it.

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 it. This is quite easy as you only have to give your server details and you will be connected.
After connecting, you should see your databases in left side of Navicat main window.
If you click on database icon, Navicat shows you a list of all of the tables. Select the table that you want to perform Import action.
Please click on Import Wizard button. Import Wizard will be started. Follow the steps of Import Wizard, you should be able to import your MS Excel/Access/XML file into MySQL database.

1
|
2
|
3
|
4
Next Page »

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:

Comment:



Comment:

(Maximum characters: 1200). You have characters left.