I have records in a temp table. The name of the temp table is tmpTable. I also have a table named Orders.
I need VBA code if possible that will delete all existing records in the table named Orders and import the records in tmpTable into the then empty table named Inventory.
But the catch is this... the field names in tmpTable do not match the field names in Orders. Somehow, and hopefully all through the magic of VBA coding I can tell the process what fields map to what fields. I understand that there will have to be some hard coding of field names but that's ok.
Can someone help?