Re: MSAccess to postgres on Windows Currency type problem - Mailing list pgsql-odbc

From Tom Lane
Subject Re: MSAccess to postgres on Windows Currency type problem
Date
Msg-id 17626.1315868883@sss.pgh.pa.us
Whole thread Raw
In response to Re: MSAccess to postgres on Windows Currency type problem  (albert <skarbat@gmail.com>)
List pgsql-odbc
albert <skarbat@gmail.com> writes:
> 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.

It looks like you're using a locale in which the decimal separator is
comma rather than period.  Perhaps changing some locale setting on the
MSAccess side would help?

            regards, tom lane

pgsql-odbc by date:

Previous
From: albert
Date:
Subject: Re: MSAccess to postgres on Windows Currency type problem
Next
From: Arvind N
Date:
Subject: psqlodbc-09.00.0310 Crash issues with aggregate function based queries.. specifically SUM and AVG.