OPENDATASOURCE join doesn't return all the data?


I'm using OPENDATASOURCE to connect to a csv file and join that to a local table, but only a subset of the data is returned.

Does anyone know the reason for this, I'm think it's something to do with the way the oledb drivers caches data or something like that?

Many Thanks