>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