SQL Assistance - Output to File


L

Luminox

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?
 
Ad

Advertisements

Ad

Advertisements

G

Glenn Adams [MVP - Retail Mgmt]

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 Consulting
http://www.tibercreek.com
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need SQL Assistance 1
XML file output 1
Converting text files from scanner output 2
Outputting Data 3
USA Output Calculation 0
USA Output units for a bodyshop 1
assistance 2
MSR Output Format 0

Top