Is the structure of the all of the CSV files the same?
Or are all thethe headers all the same?
In general steps:
The first thing you need to do is select the folder where the files are stored, unless you want to hard code the path to be "T:\Inbound". Or you can default the initial folder to "T:\Inbound" and still allow you to pick a different folder.
Then you need to create a list of all the CSV files in the folder and all of the subfolders. The list can be a table, list box, array, ....
Next you will loop through the "list" of file paths & names to import each of the files.
Your process to move the data to other tables can be run after each import
or after all files have been imported.
You will have to explain what you mean by the "latest" file.
After you import the file, I would move it to a different folder if you need to keep it for a while or delete it so it doesn't get imported a second time.
-------------------------------------
You can use FSO to select a folder.
Here are two sites with code to call the Dir command recursively.
http://www.ammara.com/access_image_f...er_search.html
http://allenbrowne.com/ser-59.html
You could use the "TransferText" command with an import spec to import the files.
Last is you code to process the files.