Converting text from asp.net into .csv

One painful experience we have had this week has been in converting some data from one of our databases into a .csv.  This sounds simple doesn't it ??  however there were very specific requirements as the .csv had to be imported into a second system. 

We were using the stringbuiler.append method but found that the only way this would work was via the Stringbuilder.appendline method.

anyway hope this can help someone else out there.

C