Why would you select "dbase 4"? I believe dbase 3 is a much more compatible format, and suspect that VFP might have trouble with dbase 4.
>I have a spreadsheet that I am "exporting" as a dbf file using "Save As" in Excel and selecting "dBase4" as the output file type.
>
>Aside from the fact that 1 or some columns seem to cause an error when opening in VFP (a subset of the columns, when saved as, opens OK), none of the numeric fields with decimals is showing any decimals, ending up as "N(5,0)".
>
>I am using the following to set the column format:
oSheet2.Cells(1, xx).NumberFormat = "##,##0.00_);[Red](##,##0.00)"
and I have even gone to the trouble of filling the first data row with the value 0.01 before doing the "Save As".
>
>Anyone know how I can get decimals reflected properly?
>
>Thanks
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)