Is your question how to upload the data from DBF to SQL Server
Or how to use SQL Server data in a FoxPro app
If the former, you can use:
- SQL DTS
- Batch update.
- Upsize Wizard
If the latter, you would have to design your app as a 2 -Tier or 3-Tier application getting your data to/from SQL Server through one of these technologies:
- SQLPassThrough (ODBC)
- Remote Views (ODBC)
- CursorAdapter (OleDB+ADO or ODBC or XML)
- Convertion to/from XML
It all depends on your needs, data volume, type of data and architectrure. You would have to give more info to be more specific in our answers.