Search code examples
mysqlexcelmysql-workbench

Copy from MySQL Workbench to Excel

I have to build reports, and I need to do some database queries, which return a bunch of results.

Is there a way I can copy 1+ rows/columns and copy them into an excel sheet? the excel sheet is formatted a particular way, and the data needs to be placed in there a certain way, so how can I copy and paste from mysql workbench into excel?

Solution

  • The best answer I could come up with is to use a different program:

    http://www.heidisql.com/

    So far this program works great! I like it a lot better than MySQL Workbench as well!