>>Try

SELECT * FROM OPENROWSET('MSDASQL',
>>'Driver=Microsoft Visual FoxPro Driver;SourceDB=c:\temp\ims.dbc;SourceType=DBC',
>>'SELECT * FROM zipfl')

You can also create a linked server.
>
>I get this error:
>
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDASQL' reported an error.
>[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver does not support this function]
>OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].

I just successfuly run following select in Query Analyzer

SELECT * FROM OPENROWSET('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceDB=E:\Program Files\microsoft visual foxpro 9\Samples\Tastrade\Data\Tastrade.dbc;SourceType=DBC',
'SELECT * FROM customer')

Can you access that table with ODBC?