I attached an Excel File name "Test Run" and an Access file named "Test Run"
I have the files link. When I update columns AH Through BA in Excel to Access I want the new info to update, but I want the old info archive to retrieve and review in a query. Columns AH Through BA should be link to Column "A" in Excel (Group ID)
Desperate help needed. Thanks. Test Run Database.zip