Thanks Sergey, It work fine with OPENQUERY. I don't think VFP OLE DB is installed on the SQL Server machine and I don't know how to check if it's installed. But I think I will use ODBC (I read that OLE DB is too slow).

>>here are the two error messages I got (sorry, but they're in french)
>>
>>Test #1
>>

>>exec sp_addlinkedserver @server = 'test',
>>	@srvproduct = 'VFP',
>>	@provider = 'VFPOLEDB.1',
>>	@datasrc = 'C:\Temp',
>>	@provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'
>>
>>select * from test...livre
>>
>>Serveur : Msg 7403, Niveau 16, État 1, Ligne 1
>>Impossible de créer l'entrée de Registre pour le fournisseur OLE DB 'VFPOLEDB.1'.
>>

>
>Sorry but I don't understand french. Do you have VFP OLE DB provider installed on SQL Server PC?
>
>>Test #2
>>

>>exec sp_addlinkedserver @server = 'test1',
>>	@srvproduct = 'VFP-ODBC',
>>	@provider = 'MSDASQL',
>>	@provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=;
>>		Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No;
>>		Exclusive=No; SourceType=DBF;SourceDB=C:\Temp'
>>
>>select * from test1...livre
>>
>>Serveur : Msg 7314, Niveau 16, État 1, Ligne 1
>>Le fournisseur OLE DB 'test1' ne contient pas la table 'livre'.
>> La table n'existe pas ou l'utilisateur en cours
>>ne possède pas d'autorisations sur cette table.
>>

>>
>>in the test #2, the file livre.dbf is located in the C:\TEMP directory and there is no special athorisation to access it
>
>For part reference dosn't work for free tables. You have to use OPENQUERY

SELECT * FROM openquery(test1, 'select * from livre')
>ISERT INTO openquery(test1, 'select * from livre') (...) VALUES (...)

See BOL for details. Take also look at Re: Linked server with the database on VFP Thread #700708 Message #727555.