Exporting Simple English data into FoxPro 2.6 dbf

Could any one help me in

Writing code/query to export simple English text data from MSSQL Sever2000 to FoxPro2.6 dbf


[email protected]

You can use dts or linked server.