>>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.