Usage information table
Count to record number
The first record = 1
For t= 1 to the upper limit (number of records /5000)
If t * 5000 & gt record number
Last record = number of records
other
Last record =t*5000
endif
Table name = IIF (t
Table name xls= first record copied to & amprecn () >. And.recn () < = last record
The first record = the last record+1
endf
If you are not familiar with this command, I suggest you create this program file directly by copying and pasting. After running, you can generate all the required Excel table files in the default directory.