| From: | albert <skarbat(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | MSAccess migration to Postgres through ODBC |
| Date: | 2011-09-10 20:38:24 |
| Message-ID: | CAGt3jCpmhnZti0w5eSKRdLNaqf=p1y6NffcuTHO3Gy9vL4UPhQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
I am exporting a MSAccess database to Postgres under windows using ODBC.
An Access table has a column with Currency data type.
When trying to export that table I get a popup message saying the ODBC call
failed,
"the input syntax is invalid for type double precision <40868,8227>" .
(it's not a verbatim error message as I am running Spanish windows version)
I have tried to export that same table using mdbtools' mdb-schema program
and it works correctly, translating it to postgres "money" data type.
Any ideas on how to fix this? I have not found any related settings on the
ODBC driver applet.
Thanks
Albert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rural Hunter | 2011-09-11 01:17:13 | Re: Backup Question for Point-in-Time Recovery |
| Previous Message | Guillaume Lelarge | 2011-09-10 17:30:48 | Re: Backup Question for Point-in-Time Recovery |