Create a script file Assuming you've installed the AdventureWorks2022 sample database, follow the example in this section to create a script file that you can run from the command prompt with sqlcmd.

With this excel macro, you can run SQL to any text file (need to be either csv or tsv format), and get the result to the excel sheet or can export to csv file. It also contains "automation" ...