0

I have 9 queries that I am trying to post the output to an organized form such as excel. What I am mostly trying to do is be able to post all the information from the queries to a report that neatly displays the information. Using excel, or etc. what is the best method for doing this. Should i just use a webpage and do php? What other methods have others used? Also I am using PHPmyadmin, I know that there is an export function but how would I do it all at once with 9 queries.

user3385236
  • 49
  • 6
  • Need to know your RDBMS. Most allow arbitrary queries to be exported to CSV, but they vary quite a bit and are vendor-specific. To generate a true .xlsx file is more complicated, however. – Bacon Bits Aug 20 '14 at 16:15
  • MySQL, I'm just trying to get something that outputs all of them, so i dont have to get each bit of info and create a new report every day. – user3385236 Aug 20 '14 at 16:26
  • In that case: http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format – Bacon Bits Aug 20 '14 at 18:33

0 Answers0