Hi Demosth,
Based on my research, you can import DBF files into SQL Server tables by using Import/Export Wizard. For more details about the whole process, please review this blog:
Importing DBF files into SQL Server.
Another option is to download
Microsoft OLE DB Provider for Visual FoxPro and then use
OPENROWSET method to import data from DBF files into SQL Server tables. For more details, please review this similar
thread.
After importing DBF files into SQL Server tables, you can use T-SQL to retrieve data. As you need to access the data with Clipper code, you might need to do programming, and I would recommend you post the question in the
Visual FoxPro General forum to get better support.
Thanks,
Lydia Zhang
Thank you. I was aware that I could import the data relatively easily into SQL server. But we have numerous applications written in Clipper and now compiled and linked with Flagship. Six of these systems are complicated insurance administrative systems. Do you really think that the VFP forum can help? there are no plans to convert the code at the moment.
>> Do you really think that the VFP forum can help?
Probably more then this forum :-)
* I am closing this issue by marking Lydia Zhang's response as the answer