• Following up on the BCP suggestion this is actually a good idea >

    Open a command line window and type something like

    bcp "adventureWorks2008R2.Person.address" out "c:\myBcpOut.txt" -c -T

    If you need to supply user name and password (if you are not on a trusted network) then instead of the -T you will have to supply values for the -U and -P switches (-Umyusername -Pmypassword)....if you are logged into the machine you will not need to add a server name to the -S switch.

    I did the above, the table I used has commas in the address line field. I was able to open the tab delimited file in Excel and all was properly aligned.

    Give it a go

    ----------------------------------------------------