I used to do this.
1. Write some VBA to read the contents of a text file into a table. There are many examples on the internet e.g.
VBA procedure to import csv file into access[
^]
2. Write another VBA function to list the files in the folder
Microsoft Access tips: List files recursively[
^]
3. You will need some code to move the files out of the processing area once successfully loaded and I suggest also having some code that will validate that you have loaded all of the file content.
4. You can opt to have the code run as soon as you open the Access database e.g.
Create a macro that runs when you open a database[
^] or possibly better would be to use a command line switch (/x) - see
Command-line switches for Microsoft Office products[
^]
5. Schedule the process to run when you want it to using Windows Task Scheduler
How to create an automated task using Task Scheduler on Windows 10 | Windows Central[
^]
As an aside, .mdb is a very old version of Access database format - the very old versions can no longer be opened in modern versions of Access, and although the latest version of Office will still allow you to open later MDB files (Office 2000 onwards) there is no guarantee that Microsoft will continue to support that. My recommendation is to upgrade your Office installation if you possibly can and start converting your Access database(s) to .ACCDB