You will be able to open the Fox 2.6 tables in VFP6 without problem. You can even use the "COPY TO" command to copy cursors or other files created in VFP6 to the Fox2.6 version:
USE customer && Opens Customer table
COPY TO sometable TYPE FOX2X
But do not use Alter Table (or the MODIFY STRUCTURE) command from VFP6, otherwise FoxPro will save the table in the new format. Either make structural changes in Fox2.6 or use COPY TO TYPE FOX2X when done.
You should also be aware of new field types (Currency, DateTime, Double, and Integer) that do not exist in Fox26.
If I remember correctly (it's been a while since I've opened Fox26 tables in a VFP production environment), you may get codepage dialogs whenever you try to open the Fox26 tables from VFP6. If you do, then you can skirt around this by looking into the SET CPDIALOG Command (and related functions). Codepage translation is important, so be careful before you decide to just shut this off!
Thanks for given me the suggestion. Now my original table ie.vfpx 6.0 contains nearly 20 fields. I have included my own fields for validation, but i need only certain fields which is useful for customer to be sent.
So i need to create another table with the same name and copy only the fields that are necessary for the customer and dropping other fields and send this to our customer so that they can directly upload to their dbf. I am using vb 6.0 as front end.
How i have to code in vb for this particular case. I am also using .fpt for a memo field. whether it is possible to code in visual foxpro directly. I dont know much about foxpro commands. If anyone knows, Please suggest me.