Problem exporting to .dbf file.

[J Bhujanga]

I'm trying to export an Access table to a .dbf file. It works okay except that I have a couple fields that need to retain 6 digits right of the decimal point and it cuts them off at 5. Even if I set the precision higher than 6, it loses everything past 5. It exports to Excel fine, retaining all of the digits. Does anyone know how to fix this problem?

[davegri]

Try changing the numbers to decimal and adjust the precision and decimal properties.
A precision of 2 means that a decimal number can be no greater than 2 digits. (44 or 4.4 or .44)
A scale of 3 indicates 3 decimal places.