Importing Excel, Access or XML data into MySQL
October 20, 2003[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