It'll be almost the same, but SourceType=DBF and SourceDB should be the directory with free table(s).

SourceType=DBF; SourceDB=h:\Temp;

>Sergey,
>
>How would I connect to Fox 2.x tables? What would the provider string be?
>
>Guy
>
>
>
>>>The table is part of a database. I know the second syntax you give and using that syntax I get a result but that doesn't solve my original problem (combine 2 sql tables and 1 VFP table on a linked server)
>>
>>Hi Hans,
>>
>>We've two issues here:
>>
>>1. Four part name for a VFP table in DBC
>>I just tested and it works for me. The linked server is setup with Provider string only

DRIVER={Microsoft Visual FoxPro Driver};
>>Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
>>SourceDB=\\Target_1\vol_1\daily\lccqueue\testdbc.dbc;SourceType=DBC;

I would suggest that you play more with it and try to figure out why it doesn't work for you.
>>
>>2. Using OPENQUERY() in 3 table join
>>You didn't say what the problem is but the following works for me

SELECT * FROM pubs.dbo.authors au
>>	JOIN (SELECT * FROM OPENQUERY(testdbc, 'SELECT * FROM test1')) vt
>>		ON au.au_id = vt.cc
>>