How can I export some Blog posts from our Sql Server, to a file?

We have a simple website that contains (take your pick, for this example) blog posts / q & a questions / whatever. People upload text (single sentences to paragraphs .. including some white listed/approved html).

I need to export this data into .. a file / something .. so I can give the data to someone else.

eg. sample schema

Id INT
Title VARCHAR(100)
UniqueUrl VARCHAR(100)
Content VARCHAR(MAX)
ModifiedOn DATETIME
PublishedOn DATETIME
CreatedByUserId INTEGER

Is there any way I can export this data into a format that is simple to give to another person to import? I have no idea what they will import it into .. so i was guessing a csv or excel format might be sufficient. That said, one of the fields contains VARCHAR(MAX) which can have paragraphs of text.

Anyone have any suggestions?

##Update

I've tried

• Tasks -> Export Data : this always give me an error during the final step. Error message give's -noth开发者_如何学运维ing- about what happened. Total fail :(
• Run my sql script -> save results as -> .txt or .csv : file is created, but i just can't read the content .. especially since one of the fields is a VARCHAR(MAX) with the User Generated Content everywhere :(

Maybe export as XML?

What have you tried?

I'm not sure what other things I can try / what options there are, besides the two, above.

XML is going to the be the simplest solution here. The line breaks will rip apart most csv readers, and the quotation marks will finish off the rest.