You can insert records into a table in another database, if you want to go against the advice proffered by others, by using
currentdb.execute "insert into tblExternal (Field1, Field2) in 'C:\path\yourOtherDatabase.accdb' select Field1, Field2 from tblSourceTable"