Looping error while reading in Access VBA code- error 3314

Some of my Excel files have only 2 records , some files have 160 records how can I change the FOR loop accordingly?
or is there a better way to check and loop and update the table?

Please Login or Register  to view this content.

Thank you