How can I generate a .xlsx file from a batch file using sqlcmd?
I have a sql script that my batch file is executing, and I’m generating a .csv file with the >> syntax. When I switch the .csv to .xlsx, then the file doesn’t place the distinct data elements into separate columns.