The following works for me

SELECT a.*
FROM OPENROWSET('VFPOLEDB.1', 
'C:\Program Files\Microsoft Visual FoxPro 7\Samples\Tastrade\Data\tastrade.dbc';;,
   'SELECT * FROM supplier') AS a
-- Or
SELECT a.*
FROM OPENROWSET('VFPOLEDB.1', 
'C:\Program Files\Microsoft Visual FoxPro 7\Samples\Tastrade\Data\tastrade.dbc';;,
   supplier) AS a

Notice double ";" semicolon after the database name.

>What's the syntax for using the VFP OLE DB provider with SQL OPENROWSET? I'm trying the following:
>
>

>SELECT a.*
>FROM OPENROWSET('VFPOLEDB.1','C:\Program Files\Microsoft Visual FoxPro 7\Samples\Tastrade\Data\tastrade.dbc',
>   'SELECT * FROM tastrade.suppliers') AS a
>

>
>and getting the following:
>
>

>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'VFPOLEDB.1' reported an error.
>[OLE/DB provider returned message: Invalid path or file name.]
>

>
>Can't seem to find much documentation on this (mutter...mutter).