按记录数分成不同库
请教下,我有一个14760记录的表,我想按照每5000条记录,生成一个以记录数命名的dbf,比如A5000、A10000,代码应该怎么写啊?我自己的思路是这个:
n=0
for i=1 to reccount()
n=i+5000
select * from A where recno() between i and n into dbf 'Ai'
sele * from 表 where recn()<=5000 into dbf A5000 sele * from 表 where recn() betw 5001 and 10000 into dbf A10000 sele * from 表 where recn()>10000 into dbf A15000