>SELECT a.* FROM OPENROWSET('VFPOLEDB.1', 'd:\data\mydbc.dbc';;, 'SELECT * FROM mytable where type ="CM"') AS aAnthony,
Have you tried instead setting up a linked server that uses OLE DB to access the data and then using OPENQUERY()?
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer