Re: encoding confusion with \copy command

On 09/17/2014 06:48 AM, Martin Waite wrote:

Hi Adrian,

I apologise - I meant 9.4

Looks like you will need an intermediate step. A quick search found the below which might offer a solution:

http://www.excel-sql-server.com/sql-server-export-to-excel-using-bcp-sqlcmd-csv.htm

FYI the good stuff is at the bottom.

There is also this SO answer that refers to SQL Server Management Studio(not sure if you have):

http://stackoverflow.com/questions/6115054/how-to-get-export-output-in-real-csv-format-in-sql-server-managment-studio

regards,
Martin

--
Adrian Klaver
adrian.klaver@aklaver.com