Store different query results into different Sheets of the same excel

Adalat Khan

5y932SQL

Hi,

I have three queries that generates three different excel files on the disk and store the queries results in three different excell files. Following is my Queries:

SELECT * FROM Table1

INTO OUTFILE 'C:\\SFTP_ROOT\\MicrowaveLan.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n';

SELECT * FROM Table2

INTO OUTFILE 'C:\\SFTP_ROOT\\MicrowaveLanTX.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n';

SELECT * FROM Table3

INTO OUTFILE 'C:\\SFTP_ROOT\\MicrowaveLanRX.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n';

Actually i want to create a single excell file in the specified path and want to store the result of each query in the same excel file in different sheets for example, the result of Table1 will go to Sheet1, the result of Table2 will go to Sheet2 and the result of Table3 will go to Sheet3. Also i need to rename Sheet1 as Table1, Sheet2 as Table2, and Sheet3 as Table3.

Currently my files are in CSV format but i want to store them in a single excel file

How can i do it please help. Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Adalat Khan5y ago
Dears i don't want to use programming code but actually i have MySql Event which is executed after 24 hours. In that event i have three different queries which export data from three different database tables into three different excel files and store those files in my computer local disk. Now i want to use such a query which create a single excel file on my computer local disk and export the data of table1 into Sheet1, the data of table2 into Sheet2, and the data of Table3 into Sheet3. I need just query not programming code.
Mageshwaran R5y ago
https://www.youtube.com/watch?v=dse9h2W4ejw
Jignesh Kumar5y ago
Hi Adalat,

Please use this link which will help you,
https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/how-to-export-multiple-data-tables-to-multiple-worksheets-in/