>I'm trying to save an Excel97-file to DBF3 like this:
>
>WITH ox.activeworkbook
> .SaveAs(lcFilename, 8)
> .saved = .t.
>ENDWITH
>
>The only problem is that some numeric fields are empty in the resulting table and I have no clue why. Most of the values in the same column are correct. Has anybody seen this before? Of course I have tried every trick I know to ensure that data in Excel has correct numeric format but this doesn't seem to be enough.
Check if all the numbers are really saved as numeric. Some may be interpreted as text.
Change the allignment to "General" - a real number is right-alligned in this case.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)