>

>SELECT c.*, o.*
>FROM SmtNtLight.dbo.MemberCounters AS c INNER JOIN
>   OPENROWSET('VFPOLEDB.1',
>   'c:\NT Light\Database\Setup.dbc';'';'',Members)
>   AS o
>   ON c.Member_ID = o.Member_ID
>

>
>The above returns
>
>Server: Msg 446, Level 16, State 9, Line 1
>Cannot resolve collation conflict for equal to operation.
>

I assume the _ID fields are character? Try to add "COLLATE Latin1_General_CS_AS_KS_WS" to the last line of your query.

BOb