Hi Jim,
I agree with Hilmar, DBASE3 does a much better job. But on the occasions I used DBASE4, I think what I had to do was add a first row that had sample data in it. For example, 9999999.99. Then after importing, delete that row.
Hope this helps,
Ken
>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