[AccessD] Move Data from SQL Table to Access FE Table

I'm learning to use SQL as a BE for Access apps.  The connection method is
OLEDB rather than ODBC tables.

I would like to copy a list of record ID's from a table in the SQL BE to a
local FE table each time a process screen is opened.  I'm doing this by
opening a view from Access, creating an ADODB recordset, and then looping
through that recordset to insert the ID numbers into a local FE table.

But, looping to do this seems quite inefficient for hundreds or thousands of
rows. 

Is there a better way?

Thanks!
Dan