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