Skip site navigation (1) Skip section navigation (2)

Re: MSAccess to postgres on Windows Currency type problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: albert <skarbat(at)gmail(dot)com>
Cc: aihtdikh(at)gmail(dot)com, pgsql-odbc(at)postgresql(dot)org
Subject: Re: MSAccess to postgres on Windows Currency type problem
Date: 2011-09-12 23:08:03
Message-ID: 17626.1315868883@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
albert <skarbat(at)gmail(dot)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

In response to

pgsql-odbc by date

Next:From: Arvind NDate: 2011-09-22 07:10:58
Subject: psqlodbc-09.00.0310 Crash issues with aggregate function based queries.. specifically SUM and AVG.
Previous:From: albertDate: 2011-09-12 19:35:33
Subject: Re: MSAccess to postgres on Windows Currency type problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group