A question I am often asked is how can I create better reports from the data that is in the mySQL database for transactions processed by PHPeSeller or by PHPSecureArea. Both of these have sales history displays but you may wish to process the data in another application such as MS Excel or MS Access.
One approach is to extract the data from mySQL using your web server control panel. Login into the control panel of your server and find the section that deals with mySQL. You should have a link to myPHPAdmin or a similar database tool.
Navigate to the correct database in myPHPAdmin. Navigate to the table that you want to export and at the top of the page you should see an EXPORT tab. Click on this. You will need to select a particular format for the export. This is normally CSV for Excel or CSV. CSV stands for Comma Separted Values and is a very common method of transfering data to and from different application. That should then allow you to download the file which can then be opened in your required application.