hi,

thank you ,it works fantastic if mytable have a number exactly as 500000,

but if mytable have 5000001,give error message(end of file encountered)

use test
go top
i = 0
do while not eof()
  copy to ("test" + trans(i)) next 100000
  skip  && (end of file encountered)
  i = i + 1
enddo

thanks.

best regards
m.qasem