Tim,
Maybe the following MSDN articles could give you some ideas:
Q199131
Q207595
HTH
>I was playing around with SQL Server. I made a link to a VFP database (free tables..) I can see the tables in the linked severs section but I donøt know the syntax to query the server....
>
>Anyone know how to do it?
>
>On MSACCESS this works:
>SELECT * FROM MSACCESS...Titles
>
>But for VFP what do I do?
>EXEC sp_tables_ex VFP (works)
>SELECT * FROM VFP...SUPPLIER (doesnt work gives error about wrong schema specification)
>
>
>However, it does know that the table doesn't exist if I type in some bullsh...
>table like:
>SELECT * FROM VFP...XXXX (give correct error (table doesn't exist))
>
>In the SETUP I create an ODBC DSN called VFP that points to my data dir.
>Then in each field I used VFP for all the values.
>
>I tried everything...even:
>SELECT * FROM VFP.VFP.VFP.SUPPLIER
>
>
>(I need to extract some info from a VFP app without changing it in order to use it in a SQL Server APp.)
>
>Thanks
Daniel