Export to foxpro

[DrewDog_21]

Can anyone give me an example on how to create a foxpro table and export data from an existing Access table to it?

Thanks

Andrew

[sodhichd]

The easy way is the use DAO.
Create two recordsets. One for Foxpro and one for access. Then using a for loop read all the data from the access table and inside the loop trf. it to the foxpro recordset and update it.

Regards
Manjinder Sodhi

------------------