Dim i As Integer
dim intTmp as integer
'查询出你需要的记录:rsOld
For i = 1 To rsOld.RecordCount
intTmp =intTmp +1
rs.AddNew
rs.Fields("Name").Value = intTmp
rs.Fields("a").Value = rsOld.Fields("a").Value
rs.Fields("b").Value = rsOld.Fields("b").Value
rs.Fields("c").Value = rsOld.Fields("c").Value
rs.Update
Next