>the problem is in the SELECT FROM command

Ah, I see. In the documentation, I don't note that there's any reference to using the fully qualified name and path. Further, VFP searches the current Fox path (SET PATH TO...) when trying to execute a query. You can't expect it to return the file name with every path on it, can you?