You have to use OPENQUERY

SELECT * FROM openquery([LinkServerName], 'select * from mytable')
ISERT INTO openquery([LinkServerName], 'select * from mytable') (...) VALUES (...)

>I have a client trying to use SQL Server 2000 to access old FOXPRO 2.6 for Dos data tables. The problem were having is using a Linked Server with the 4 part name convention. Everything looks right, but we get an error from the ODBC driver that states "Unrecognized Phrase In Keyword" error. In foxpro that means that it did not like part of the expression trying to open the table. It then returns the string it thinks it is looking for. which has an extra '\' between the catalog and table name. No matter how we try to describe the catalog or the table to use it still bombs. No schema is setup. I tried using an older DBASE IV ODBC driver, which liked the syntax, but always locks the table (even with exclusive off) this is a network app so its always in use.
>
>ANY IDEAS?