Export data to text file

Does anyone knows how to export data from SQL to a text file and excel?
I really need you help badly.

If you use Crystal Report, I will be very easy to export to Excel files...

When you say "from SQL " do you mean from an SQL server database or from a .Net DataSet that you have populated from an SQL command?

For the first case, I think SQL server DTS export task has options of exporting tables to both excel and text formats.

For the second case, you can save the dataset as an XML file by using GetXML() on the DataSet and doing whatever you want on the resulting XML file.