Writing the loop for updating multi-table MS access file using multi-sheet excel

I imported the tables (DKt and DTt) from an ms access file to excel sheets (DKe and DTe), each table corresponds to one sheet. Now I want to update the ms file, when some changes happen in excel file. I wrote different loops for different worksheets and tables as shown in the code, but I have more than 8000 rows and it takes a long time to run.
Is it the only way or there is another way to write the loop for all tables and worksheets? I also get an error, when I run the macro in a older version of microsoft (2013) for the line of

Please Login or Register  to view this content.

that

Please Login or Register  to view this content.

, how can I get result with different version? Here is my macro for updating the tables in ms file from excel sheets:

Please Login or Register  to view this content.

Originally Posted by alansidman

Why not link the Excel tables to Access and then every time you make a change to the tables in Excel, they are automatically updated in Access. No need for loops or imports. Replace the tables in Access with the linked tables from Excel.

I also imported the tables from excel using External Data in access and Import the source data into a new table in the current database, but for updating the changes in access we need to write macro in excel to save those changes in access. If you mean another way without using macro can you please explain more?