- 1,251 categories
- 40,829 scripts
- 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.