You can do "heterogenous joins / queries" with SQL Server on OLE DB data sources that reside on the same, or different servers ... meaning you can retrieve from both DBFs and SQL Server data using SQL Server.

>Chris, thanks so much for your response.
>
>The request from the VB programmer was that we do the updates to his SQL server directly from Foxpro which yes, I do realize we can do. I was just hoping that he could pull from the Foxpro db through VB effectively because we will have to stop a project already in progress to complete this request.
>
>Thanks, CJ