Problems with currency

[dreniarb]

My Access fields that contain currency do not get imported properly. The amount is rounded up. Any suggestions on getting it imported properly?

Thanks.

[dreniarb]

Partial answer to my own question I think. Looking at the table structure, it's set as decimal (which seems to be the best one for currency), but it's set to 19,0 instead of 19,2. Anyway to overcome this?

[dreniarb]

I just love responding to my own questions. :)

ok, small workaround for now. My database isn't huge so I truncated all the tables, then changed each field manually from 19,0 to 19,2. i reran the import and it worked fine. The entire dollar amount is there, no rounding.

Hope this is helpful for someone else.

I do have about 40 other databases to convert. if this problem could be fixed in a newer version i would be inclined to donate for it.

Thanks for a great product. Other than the decimal places it seems to have worked perfectly!

Jason

[jr]

Hi Jason,

Thank you for clearing this up. I will try to fix it if you send me a small sample of your database that reproduces the problem. Please send it to the email address at the link below:

http://www.bullzip.com/products/pdf/inf ... anslations

Regards,
Jacob