>>Hello,
>>
>>Working with VFP 6.0 SP3
>>
>>If I save a table (copy to....) to a DBF, the table cannot be opened with Excel (97), Access(97) or any other dbf-compatible program.
>>The problem did not exist with VFP 5.0-created dbfs
>>
>>Does anybody know the cause and/or solution (I need to read the dbf, I do not want to copy to....xl5
>
>You can COPY TO...TYPE FOX2X to force VFP to write a backwards-compatible DBF as long as you are not using any of the new data types in the table. Older versions of the Office suite do not understand the newer DBF headers (FoxPro 2.x doesn't either...)

If your going to copy to a different file type, you just as well COPY TO...TYPE XL5.