[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mdbtools-dev
Subject:    [mdb-dev] negative value instead of positive one
From:       Marc Deichmann <marc.deichmann () gmx ! net>
Date:       2003-08-10 10:01:00
[Download RAW message or body]

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. 

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

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

["signature.asc" (application/pgp-signature)]
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
mdbtools-dev mailing list
mdbtools-dev@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[prev in list] [next in list] [prev in thread] [next in thread]