In.Net, how can I bulk transfer sql (export) tables to csv or tsv files?

c# sql sqlbulkcopy

Question

Are there any .Net libraries that provide a way of exporting sql database data to plain text files (i.e. csv\tsv)? SqlBulkCopy only applies to the import part of the solution and I prefer not to be calling any Process.Start calls to open up command prompts to call bcp.exe.

1
3
10/13/2010 6:41:19 AM

Accepted Answer

Ended up using bcp Process calls unfortunately

3
12/7/2010 8:24:49 AM

Popular Answer

Check out FileHelpers - it allows you to easily load or save data from CSV or other text file formats. Excellent code base, freeware, full C# source available - can't recommend it enough!



Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow