Hey, Kevin...
I've done it by using the VFP OLE DB Provider - once you use the provider, you can query VFP tables. You can find it on the VFP site. It's very easy to use.
(If you're using the Provider for VFP9, you can have stored procs in the DBC that returns tables as result sets).
Kevin