> -----Original Message-----
> From: Brett Maton [mailto:matonb@hotmail.com]
> Sent: 12 January 2002 14:49
> To: dpage@vale-housing.co.uk
> Subject: RE: [pgadmin-hackers] pgMigrate
>
>
> Hi Dave,
>
> Thanks for the letting me know about the logs, guess I
> should have looked
> around a little more ;). I did find the offending field not
> sure how they
> managed to get that value in thier in the first place!
>
> Looking through the log though it would appear that the
> Access Date/Time
> field is out put as dd/mm/yy in single quotes. Is this
> affected by the
> format value setup in the Access DB ?
It shouldn't be. ADO/DAO/RDO/Jet etc are fairly clever and will normally
figure out a date as long as it's in a reasonable format. I'm not sure
pgMigration is doing quite what it should though, but then, I'm not 100%
sure what is correct here either. I'll think about it some more.
Regards, Dave.