SQL Server Table Dump - Not All Columns

Question

I'm trying to do an SQL Server dump of a couple of tables in a database (Microsoft SQL Server). We don't have write access to the DB, so we can't do what I was originally thinking (create temp db, copy tables (minus the columns we don't want into the temp db, and then dump that db). I really can't figure out a way to do this.

A csv export doesn't work (it's almost impossible to put the data in the correct fields b/c of newlines).

Any tips?

Answer 1

Bulk Copy is your friend

Answer 2

Either bulk copy, or create a DTS (or SSIS) package that exports to a MS Access database. In access, all the line breaks will be preserved within their corresponding text fields.