Importing Excel, Access or XML data into MySQL

Monday Oct 20th 2003 by DatabaseJournal.com Staff
Share:

This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a MySQL Admin Tool called Navicat.

[From Stardeveloper.com]

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.

The article continues at http://www.stardeveloper.com/articles/display.html?article=2003101901&page=1

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved