主要语句如下:strConnect = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\db1.mdb"Set connConnection = New ADODB.ConnectionconnConnection.CursorLocation = adUseClientconnConnection.Open strConnectSet rsRecordSet = New ADODB.RecordsetrsRecordSet.CursorType = adOpenStaticrsRecordSet.CursorLocation = adUseClientrsRecordSet.LockType = adLockPessimisticrsRecordSet.Source = "Select * From 表1" rsRecordSet.ActiveConnection = connConnectionrsRecordSet.Open If rsRecordSet.EOF = False Then rsRecordSet.MoveLastrsRecordSet.AddNew然后用for语句给各个字段赋值……rsRecordSet.Update rsRecordSet.Close '关闭记录集可是用Access打开数据库时,发现好多记录并不是追加到数据库最后,而是插入到了中间。请问怎样才能把新记录按顺序追加到数据库中?