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)

The code is like this:

DoCmd.TransferDatabase acExport, "dBase 5.0", Pfad, acTable, "TBL_Export", "export.dbf", False

Please help.