Importing from Access 2000?
От | Bjorn T Johansen |
---|---|
Тема | Importing from Access 2000? |
Дата | |
Msg-id | 35016.193.212.14.12.1051616561.squirrel@www.havleik.no обсуждение исходный текст |
Ответы |
Re: Importing from Access 2000?
Re: Importing from Access 2000? |
Список | pgsql-general |
I am trying to convert an Access database to PostgreSQL and the import works until it comes to timestamps, then I get error msg like these: ERROR: Bad timestamp external representation '0000-00-00 01:00:00' ERROR: Bad timestamp external representation '0000-00-00 15:50:00' ERROR: Bad timestamp external representation '0000-00-00 17:20:00' ERROR: Bad timestamp external representation '0000-00-00 18:20:00' ERROR: Bad timestamp external representation '0000-00-00 18:30:00' ERROR: Bad timestamp external representation '0000-00-00 18:40:00' ERROR: Bad timestamp external representation '0000-00-00 18:50:00' ERROR: Bad timestamp external representation '0000-00-00 19:00:00' ERROR: Bad timestamp external representation '0000-00-00 23:00:00' ERROR: Bad timestamp external representation '0000-00-00 23:30:00' ERROR: Bad timestamp external representation '0000-00-00' ERROR: Bad timestamp external representation '0000-00-00 00:30:00' ERROR: Bad timestamp external representation '0000-00-00 01:00:00' ERROR: Bad timestamp external representation '0000-00-00 19:00:00' Does anyone have any suggestion on how to overcome this problem? (BTW, I am using PostgreSQL 7.3.2 and ODBC) Regards, BTJ ----------------------------------------------------------------------------------------------- Bjørn T Johansen (BSc,MNIF) Executive Manager btj@havleik.no Havleik Consulting Phone : +47 67 54 15 17 Conradisvei 4 Fax : +47 67 54 13 91 N-1338 Sandvika Cellular : +47 926 93 298 http://www.havleik.no ----------------------------------------------------------------------------------------------- "The stickers on the side of the box said "Supported Platforms: Windows 98, Windows NT 4.0, Windows 2000 or better", so clearly Linux was a supported platform." -----------------------------------------------------------------------------------------------
В списке pgsql-general по дате отправления: