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

Re: MSAccess to postgres on Windows Currency type problem

From: albert <skarbat(at)gmail(dot)com>
To: aihtdikh(at)gmail(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MSAccess to postgres on Windows Currency type problem
Date: 2011-09-12 19:35:33
Message-ID: CAGt3jCoVNayoz9qXJ2QH3y6pRHjAEaOihyeUvqX-otNiayx+CA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks Harun,

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/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.
>
> Regards,
> Harun
>
>
> 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
> type.
> The process just stops half way through there's no way I can export that
> table.
>
> 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
>> program
>> > and it works correctly, translating it to postgres "money" data type.
>>
>>  the postgresql data type you want is NUMERIC.
>>
>> http://www.postgresql.org/docs/9.1/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
>>
>>
>> --
>> Regards,
>> Richard Broersma Jr.
>>
>
>
>

In response to

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2011-09-12 23:08:03
Subject: Re: MSAccess to postgres on Windows Currency type problem
Previous:From: AlbertDate: 2011-09-12 09:54:43
Subject: Fwd: ODBC breaks on some machines

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