Ascii text file

To export a table from sqlserver to text file you can use DTS wizard.
If you want to do it through code, you can try the following:

FileStream fileStream = File.Open(@"C:\Temp\NewText.txt", FileMode.Create, FileAccess.Write, FileShare.None);
StreamWriter streamWriter = new StreamWriter(fileStream);
foreach (DataRow dr in dataSet.Tables[0]) //datSet having your required records
{
//change /t to required formatting you want
streamWriter.WriteLine(dr["ColumnName1"].ToString() + "/t" + dr["ColumnName2"].ToString());
}
streamWriter.Close();
fileStream.Close();

Hope this will help..