Converting Tables into Comma-delimited ASCII Text files

Is there an tool that can be used to convert a table into a comma- delimited ASCII text file?

Dear meetbishop,

Use Microsoft Access. It allows you to export your table as csv.

Another option is to create a tool like the one displayed here

http://www.codeproject.com/aspnet/ImportExportCSV.asp

HTH,

Suprotim Agarwal

|||

do u want to convert the table's data into comma delimitted ASCII file? or u want only Table Name?

If u want only table name u can use SQLCMD -q"Select Name+',' from Sys.Tables" -O"outputfilename.txt"

Madhu