Обсуждение: MSAccess migration to Postgres through ODBC
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
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
albert wrote: > I am exporting a MSAccess database to Postgres under windows using ODBC. If you haven't already tried there, you might want to try the pgsql-odbc list. -Kevin
Thanks Kevin,
I could csv-export the table correctly, so no corruption apparently. I found a registry key called "LocksPerPage" that belongs to MS Office, after increasing it I was able to translate MSAcces Currency type to Integer successfully. Exporting through ODBC right after that was also successful. However that doesn't ring me a bell on how one can automagically export an MSAccess table through postgres odbc when having a column with Currency data type.
I could csv-export the table correctly, so no corruption apparently. I found a registry key called "LocksPerPage" that belongs to MS Office, after increasing it I was able to translate MSAcces Currency type to Integer successfully. Exporting through ODBC right after that was also successful. However that doesn't ring me a bell on how one can automagically export an MSAccess table through postgres odbc when having a column with Currency data type.
Thanks Richard for your suggestion.
Regards,
Albert
2011/9/11 Kevin Grittner <Kevin.Grittner@wicourts.gov>
Regards,
Albert
2011/9/11 Kevin Grittner <Kevin.Grittner@wicourts.gov>
albert wrote:If you haven't already tried there, you might want to try the pgsql-odbc
> I am exporting a MSAccess database to Postgres under windows using
ODBC.
list.
-Kevin