Hello.
I confess knowing nothing about MS Excel, don't run Windows, never use
it.
Anyway, I am often enough having to load Pg databases using SQL COPY
from CSV output written by Excel, that I've had to write a script to
change the quoting behavior from Excel's putting double quotes around
a field having embedded delim chars, to Pg's backslash quoting.
I've got a hunch that one or both of the aforementioned softwares can
change their quoting behavior. (IT just seems reasonable... famous
last words.)
Is it true that neither of Pg SQL \copy and/or Excel can adapt as I
wish? What about psql \copy? I fail to read in the docs for the Pg
products any support for this.
If Excel can adapt, at least one experienced user I've asked, doesn't
know about it.
Thanks.
--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305
321-1144 (mobile http://www.JerrySievers.com/