Converting a MySQL Database to an Excel Workbook
(Page 1 of 4 )
If you are new to MySQL and you are working with either a fairly large or small database, there comes a time when you need to export your data into an Excel workbook. This article will walk you through the process.
At this point you may be wondering why you'd want to export your data from the database. The reason is simple: working with Excel will allow you to very easily analyze your data, create graphs, or even execute more user-friendly commands than you can while working with server-side MySQL.
MySQL database and Microsoft Excel are very similar to each other in the sense that both of them have tables, cells and columns. However, a serious incompatibility exists between those two technologies. MySQL is open source free software) and MS Excel is owned by Microsoft (not free of course). This means it is not straightforward to convert a MySQL database into an Excel workbook.
This article will look into the best way of converting a MySQL database into an Excel workbook in three applicable scenarios (local host using XAMPP, using phpmyadmin in the server, or working with a direct MySQL file).
Although this may seem easy for advanced users, at some point in time, things can get very confusing when exporting the database. Reading this article might help.
Next: Database structure >>
More Microsoft Access Articles
More By Codex-M
