Unanswered: Access is messing with my dbf datatypes
I need to export some MS Access tables to dbf so I can use some customized software. The other software requires a strict data structure for the dbf. What I did was import the structure from an existing dbf, add my data, and then export back to dbf.
Turns out that Access doesn't like to retain datatypes the same way that Visual FoxPro wants it. For instance, Access has a datatype called 'number' that has a field size 'double'. When I export a field like that to dbf and look at it wih VFP, it is a field of type 'number' with a width of 20 and a decimal of 5.
Does anyone have a magic solution to make sure that Access imports and exports while retaining the dbf table structure?