Unanswered: Exporting table from Access to dbase file causes 5 decimal places for number fields.
Exporting tables from Access to dbase files causes 5 decimal places for all number fields. This is unwanted since the other application which imports the dbase files expects number fields with e.g. 0 or 2 decimal places.
Does anybody know how to tell Access the number of decimal places to use for export to dbase?
I have tried the following to no avail:
- define number fields in access tables as "fixed decimal numbers" (or so, in German: "Festkommazahl")
- define the exact number of decimal places for each number field (0 or 2)
- use all available dbase Versions when exporting (dbase III, IV and 5.0)