I couldn't find the methods described by Norie. Does this work when Access is connected to external data source via ODBC?

Anyway, I had to find the solution with the recordset. So here is my code where I loop through the recordset and try to update my access table with the rs data. In the moment when it has to add data to access it gives me an error message: Run-time Error '3251': Operation is not supported for this type of object.
Can you help resolve it, please?
[VBA]Set db = CurrentDb
Set rs = dataSet
Set rt = db.OpenRecordset("Test")
If Not rs.EOF Then rs.MoveLast: rs.MoveFirst
Do While Not rs.EOF
rt.AddNew
'MsgBox rs.Fields("Region")
rt.Fields ("Region" = Trim(rs.Fields("REGION"))) 'HERE IT STOPS AND I GET ERROR
rt.Fields ("Country" = rs.Fields("COUNTRY"))
rt.Fields ("CurCode" = rs.Fields("CURCDE"))
rt.Update
rs.MoveNext
Loop[/VBA]