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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-09-12 23:08:03 | Re: MSAccess to postgres on Windows Currency type problem |
Previous Message | Albert | 2011-09-12 09:54:43 | Fwd: ODBC breaks on some machines |