Exporting Data from MySQL

Exporting data from MySql into Excel  

Log into your MySQL data server using an appropriate user name and password. We are assuming that your web hosting server has MySQL and PHP services. You can create the necessary tables in your database. The tables can be connected to a web form using PHP so that if a user subscribes to your offer through a web form the data is captured and stored in appropriate tables. You can view the tables and manipulate them to do things like sending out regular emails. You can also export the tale data to Excel for interesting calculations. The complete process is outlined in the Excel training video below. As you can observe the table data is converted into a ‘csv’ text file which can be conveniently transferred and stored as a text file using ‘notepad’. The data can next be imported into Excel as outlined earlier.

Further reading:

Exporting and importing data between MySQL and Microsoft Excel

Leave a Reply

Your email address will not be published. Required fields are marked *