syntax of insert recordset is
insert_recordset DestinationTable ( ListOfFields )
select ListOfFields1 from SourceTable [ where WhereClause ]
[ join ListOfFields2 from JoinedSourceTable
[ where JoinedWhereClause ]]
example of insert recordset is
insert_recordset TableName (field1, field2)
select field1, field2
from table2
where abc<= 1000;