I am a beginner and stumped attempting what sounds like a simple task: Repopulating Access 2007 reference tables (static) from SQL Server 2007.
I am using VBA and ADO connection to create a recordset of the SQL Server table(s) with no problem:
I can't find out how to use this recordset to...
