How to Convert Excel, Access, DBF or XML into MySQL Using Navicat?Hits: 29
*****
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.
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.
Platform(s): Windows
Date: Oct, 04 2004 Author: Ken, http://www.phpbuilder.com/columns/kenlin20031229.php3 {
Ratings}Number of Ratings: 0 Votes
Visitor Voting Booth:
{
Others Scripts}
|