You are right that I need an intermediate step. I will probably use a CSV parser that is liberal in what it accepts, but writes out strict CSV data suitable for postgres.
Thanks for the help. On 17 September 2014 15:40, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > 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.kla...@aklaver.com >
