Are you trying to move data from one database to another?
If that's the case and you have recordsets open for the identical tables in 2 databases, it would go something like this:
Let's say rsSource is the source table and rsTarget is the the one you want to append into..
Do while Not rsSource.EOF
rsTarget.AddNew
rsTarget!Field1=rsSource!Field1
rsTarget!Field2=rsSource!Field2
rsTarget!Field3=rsSource!Field3
...
rsTarget.Update
rsSource.Movenext
Loop
If you wanted to automate this, you could have a subroutine that you pass a table name to that would loop thru all fields, something like this:
Do While NOT ds1.EOF
rsTarget.AddNew
For nCtr = 0 To rsSource.Fields.Count - 1
rsTarget(nCtr) = rsSource(nCtr)
Next
rsTarget.Update
rsSource.MoveNext
Loop
BTW.. stop using DAO.. use ADO.
Good luck!
Jerry