Click here to Skip to main content
14,733,866 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hi
is it possible to export different queries into Different WorkSheets in the Same WorkBook in mysql ?
each sheet is for one query .

I wanna export output of 3 queries in 3 sheets of one excel file
I use "outfile" in my query ,, but it doesn't let me to improve the excel file and add other sheet for other queries
I want one Excel file with 3 or 4 sheets for different queries .
Posted
Updated 4-Dec-13 3:11am
v4
Comments
ZurdoDev 2-Dec-13 12:12pm
   
Depends on what you are doing. SSRS can do it. SSIS can as well. Excel can too.
Maciej Los 4-Dec-13 10:45am
   
Do you want to export data using clear T-SQL? Could it be a MS Excel with ODBC drivers?

1 solution

First of all, please read my comment. I'm not sure that it's possible to do it using clear T-SQL.

Have a look here:
MySQL for Excel - Import, Export And Edit MySQL data[^]
Exporting and importing data between MySQL and Microsoft excel[^]
How To - Guide to Importing Data from a MySQL Database to Excel using MySQL for Excel[^]

I hope it would be helpful for you ;)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900