>SELECT a.* FROM OPENROWSET('VFPOLEDB.1', 'd:\data\mydbc.dbc';;, 'SELECT * FROM mytable where type ="CM"') AS a

Anthony,

Have you tried instead setting up a linked server that uses OLE DB to access the data and then using OPENQUERY()?

Laterness,
Jon