Help in copying the data from SQL server to fox 2.x format.

[desss]

Hi pals,

We have an application developed by us in Visual FoxPro with reporting facilities by using the Crystal Report. We have developed around 40 to 50 reports for this application to generate the reports for the results stored in a foxpro 2.x type table.

Now we are migrating to VB / Sql server. Since the reporting part is complex one and the existing Crystal reports with foxpro 2.x is working fine for us, we want to fetch the data from SQL server and storing them in the same fox 2.x format. So that the existing reports need not be modified or recreated. But we do not know any command is there in VB to fetch the data and store it to the fox 2.x format. We have tried to achieve this by using the DSN to store the record in foxpro table. But while calling the Crystal report it is giving the follwing error :
PDBBTRV.DLL error.

We believe that it is due to the foxpro table not created in fox 2.x format.


We need your suggestion, to use same Crystal reports which are developed to generate the reports using foxpro 2.x type.


Thanks,
Siva / Ravi.