Hello all, I am new to Access and VBA and hope some of you can point me in the right direction. I am not asking for someone to do my job, I want to learn how to do this.

My task is to automate an access app where a user manualy imports data from printed worksheets. Currently, all this data is also available in .CSV files. I want to do all this though VBA at the click of a button on a user form.

What I need to do is:...

Sir, First, I want to thank you for your service.

I am new to Access and VBA and hope you can point me in the right direction. I am not asking for someone to do my job, I want to learn how to do this. My task is to automate an access app where a user manualy imports data from worksheets. Currently, all this data is also available in .CSV files. What I need to do is:
1. Create a temporary table
2. Count all the CSV...