If I understand your question correctly... (I think you are saying you have 500+ DBF's)
I think you are probably best to aggregate all these DBF's before trying to work on them
Create cursor ... (with the same structure as your DBF's)
lnLen = Afields(laAllFiles, "*.dbf")
For lnLoop = 1 to lnLen
Append from laAllFiles[lnLoop]
Next
Once you have them all in one cursor it's a bit easier to do select's from them.
HTH
Will
>Hi friends,
>I have a question
>
>how can I read data from multiple dbf's
>eg. I have 500-1000 pieces dbf fields are orderdate,quantity
>I wantto read quantitys between 2 date from these dbfs and finish with
>into table temp.dbf systanx
>But I couldn't find any idea for this
>
>thanks for the help
Will Jones