Peter Eisentraut, Oliver Elphick, len morgan,
Thank you.
\N did the trick with pgaccess.
I have just cleaned up over 15000 database records in BBEdit (the data
was on a Mac server) and now ama trying to remember what I did last time
to get my accents right... When will I ever learn to take note
Oliver Elphick writes:
> Tony Grant wrote:
> >Hello,
> >
> >I am importing via pgaccess a text file from another non-postgres
> >database and the NULL DATE values are written like 00/00/00.
> >
> >What I have tried is replacing 00/00/00 by 9/9/1999 and setting the
> >style to europe
Tony Grant wrote:
>Hello,
>
>I am importing via pgaccess a text file from another non-postgres
>database and the NULL DATE values are written like 00/00/00.
>
>What I have tried is replacing 00/00/00 by 9/9/1999 and setting the
>style to european and I am getting 'can't parse /9/1999
> I am importing via pgaccess a text file from another non-postgres
> database and the NULL DATE values are written like 00/00/00.
>
> What I have tried is replacing 00/00/00 by 9/9/1999 and setting the
> style to european and I am getting 'can't parse /9/1999' errors.
Try replacing 00/00/00 with
Hello,
I am importing via pgaccess a text file from another non-postgres
database and the NULL DATE values are written like 00/00/00.
What I have tried is replacing 00/00/00 by 9/9/1999 and setting the
style to european and I am getting 'can't parse /9/1999' errors.
How do I go about importing