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
Thanks Richard for your suggestion.
2011/9/12 aihtdikh <aihtdikh(at)gmail(dot)com>
> Hi Albert,
> Is Access able to do anything with the data in that column?
> For example, exporting the data to a .csv file, or even just creating
> another table with a copy of the same data.
> If mdbtools can read the data, but MSAccess itself cannot, I would suspect
> some sort of corruption in the mdb.
> On 12/09/2011 08:37, albert wrote:
> The problem is how can I get MSAccess translate that column type properly?
> Why would I need to change that manually? I have a bunch of columns of such
> The process just stops half way through there's no way I can export that
> Additionally, I have tried to change that column type from within access to
> all numeric variants, even to text type,
> prior to exporting it. Access stops half way through complaining about "not
> enough memory", which doesn't make sense.
> The table has over 620.000 rows.
> 2011/9/11 Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
>> On Sun, Sep 11, 2011 at 3:08 PM, albert <skarbat(at)gmail(dot)com> wrote:
>> > I am exporting a MSAccess database to Postgres under windows using ODBC.
>> > "the input syntax is invalid for type double precision <40868,8227>" .
>> > I have tried to export that same table using mdbtools' mdb-schema
>> > and it works correctly, translating it to postgres "money" data type.
>> the postgresql data type you want is NUMERIC.
>> Richard Broersma Jr.
In response to
pgsql-odbc by date
|Next:||From: Tom Lane||Date: 2011-09-12 23:08:03|
|Subject: Re: MSAccess to postgres on Windows Currency type problem |
|Previous:||From: Albert||Date: 2011-09-12 09:54:43|
|Subject: Fwd: ODBC breaks on some machines|