Re: MSAccess to postgres on Windows Currency type problem

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.
>