Problems with currency

General usage of Access to MySQL

Moderator: jr

Problems with currency

Postby dreniarb » Wed Aug 27, 2008 2:47 pm

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
 
Posts: 3
Joined: Wed Aug 27, 2008 2:33 pm

Re: Problems with currency

Postby dreniarb » Wed Aug 27, 2008 2:54 pm

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
 
Posts: 3
Joined: Wed Aug 27, 2008 2:33 pm

Re: Problems with currency

Postby dreniarb » Wed Aug 27, 2008 4:30 pm

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
dreniarb
 
Posts: 3
Joined: Wed Aug 27, 2008 2:33 pm

Re: Problems with currency

Postby jr » Thu Aug 28, 2008 6:31 am

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
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron