BullZip Home

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

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?

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

Thanks.