How to concatenate 2 .csv files in 1 .csv file with multiple sheets using Batch commands

There is a requirement in my project to automate some SQL queries and i did but after that one user came and ask that we do not want 2 separate .csv file we want 1 .csv file with multiple sheets

For eg. suppose there 2 .csv files "Text1.csv" and "Text2.csv" and we are sending this to users but they are coming back asking to do it like a "Text.csv" file with "sheet1" and "sheet2" sheets.

I have been using below

@echo off
cls
@echo *****************************Reports****************************
@echo.

sqlcmd -h-1 -S database -E -i "loc.sql" -o "loc2.csv"

sqlcmd -h-1 -S database -E -i "loc1.sql" -o "loc2.csv"

@echo Report is generated
@echo.

Note: I can not use any 3rd party tool like java or jscripts, neither i can use Visual studio for VBS, i have only option with batch cmd file

PS. if there is another kind of script that can write as a batch file without any need of 3rd party tool that will be great


ANSWERS:


This isn't possible as the CSV format doesn't support multiple sheets (presuming that you are trying to view the file in excel).

The most you can do with a batch script is append one file onto another

copy File1+File2 NewFile


 MORE:


 ? How to remove strings from a text file using batch script?
 ? How to remove strings from a text file using batch script?
 ? How to remove strings from a text file using batch script?
 ? How do I check that a parameter is defined when calling a batch file?
 ? Batch To Remove Character From A String
 ? How to edit multiple text lines in a .ini file using batch script
 ? batch script to copy a set of lines from the text file and paste the values in another text file
 ? Batch Script - How to write to single line of a text file
 ? End of FILE* pointer is not equal to size of written data
 ? End of FILE* pointer is not equal to size of written data