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