Hello,
I need to export a MySQL database to Excel, how can I do that?
Thanks!
I suggest that you download SQLyog and do it from that program.
the thing is that the user is supposed to have the option of export the contents of the database to excel.
i have several reports in the website, but they want the options to export.
[MOD]Please do not re-open multiple old threads to promote your software.[/MOD]
Just try this
Select * from into outfile 'abc.xls' yourmysqltable
Thats it
Regards Shahzad arain
[Do not post personal contact info here - MOD]