[mdb-dev] negative value instead of positive one

[Marc D. <mar...@gm...>]

Hi!

I have a serious (for me) problem and it seems to be that the problem is
somewhere in the mdb-tools. :-(
I wrote a perl script to fetch values out of a Access database and there
are negative values where there shouldn't be.

The thing is the following. I am importing a database from Visual Fox
Pro to Access and the using the mdb-tools to convert the data to
csv-files. The switching from positive to negative is happening between
the Access database and the mdbtools.=20

When I am looking at the data with Access the number is correct. When I
am using the gmdb2 tool the same field is negative (also in the
csv-file).

Here is an example out of the tables.=20
Right (converted csv-file with Access):
6;2000;0;10;10;" ";3183460512;3229481873;0;0
Wrong (converted csv-file with mdb-export):
6;2000;0;10;10;" ";-00000001111506784;-00000001065485423;0;0

I could manually convert the Access tables in Windows to csv tables.
This is okay for some tables but for more than 100 tables it is a
pain...

Could anyone please help me?

Thanks a lot in advance,
Marc.

--=20
 mailto:ma...@cr... | http://www.creative-sadness.de
--
Trance Gemini: Exactly where on the body is the moneymaker located?
    -- "Andromeda" (2000)