>>>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.
One big difference - VFP can natively manipulate the Fox 2 style DBF with the same set of commands after it's been copied to the new file format, not the case if it's in anExcel format.