If this is for a one-time export of data, the newer versions of Microsoft SQL have SQL Server Integration Services (SSIS). SSIS provides a very simplified Export wizard that should accomplish your goal.
Here's a walkthrough that depicts how to export tables to flat files:
http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm
... View more