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