SQL Assistance - Output to File

Jul 01, 2007 2 Replies

I wrote a SQL ('Select ... from ...') and would like the output to go to a txt file ('C:\DailySales.txt'). Can someone with more SQL knowledge tell me how I can send the output to a .txt file?


Search group for OSQL command line arguments.

It depends on how you run the query - most tools, including SO Administrator, have a "save as" or "export" command on the file menu. Just make sure you are saving the results rather than the query.

Glenn Adams Tiber Creek C> I wrote a SQL ('Select ... from ...') and would like the output to go to a

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required