How to import Excel, Access or XML Data Into a MySQL DB

Kenlin Overview We very often need to import data into MySQL databases. This becomes a tough job if we don't have a reliable and 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. I recently found Navicat, which can convert Excel spreadsheets and MS Access to MySQL databases, eliminating time-consuming data entry and the errors that may accompany it. The tool uses a Microsoft...n

Read More...

---