>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: ].