I'm using ADO to add records to a table.
The code that Iím using is a simpler form as follows where rsTIT010 is an
open recordset of the table 'TIT010'

When I check the MEM Usage using task manager it increases every time it
gets to the line 'rsTIT010.AddNew' the memory increases which is concerning
me if the number of records to add increases

Set rsTIT010 = New ADODB.Recordset

rsTIT010.Open "TIT010", myConnection, adOpenKeyset, adLockOptimistic, adCmdTable

For i = 1 To 10000


rsTIT010!Source = gReturnedTIT010.Source


Next i