>>>Yes, you can create a Linked Server to FoxPro data using the VFP OleDB driver and then use OPENQUERY, but to my experience and knowledge you'll end up pulling the entire FoxPro table in before the data becomes available in the SQL world.
>>
>>That's generally true (though you can qualify with a WHERE clause in the query), though perhaps true in some way with a few other options as well
>
>Yes, I believe also that you can you a WHERE clause, but I'm pretty sure that that WHERE clause is only within the FoxPro data. You can't use values from the SQL data in the OPENQUERY WhERE clause.
If you use dynamic SQL (which I've had to do, to use OPENQUERY to retrieve Oracle data), I would have thought that you could have. But not sure if it would work with Fox.
And something I discovered recently....if you use the four-part server naming convention, you can parameterize it (at least with Oracle). Again, not as sure when it comes to VFP. I guess it depends on how much functionality is baked into the driver.