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.
Is there a way to convert a .csv file to a .xlsx file, or create a .xlsx file after running a sql script?
I tried switching .csv to .xlsx but it didn’t format the file correctly, all the data went into the first column.
New contributor
MartaR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.