Do you really want to append the files to a table or just their paths? Or just the file names? Storing files in Access tables is not a good idea.
Since the path is the same each day, decide on whether or not it would be better to store the folder path in a table or hard code it. The former would allow easy modification should the path change, the latter requires re-writing code. Then the process is basically, for each file name ending in .xlsx (or whatever) in "C:\SomeFolder" append (INSERT INTO) your table. The path field would be set to unique. Turning off warnings at the start of the operation would suppress any messages resulting from trying to add the file path a second time. If you don't care to know it already exists and just want to have it as a unique record, then why bother figuring out if it's already there? Just make sure you have a properly constructed error trap that ensures DoCmd.SetWarnings False is not left in that state.
There's lots of info regarding looping through the files in a folder. Here's one (not necessarily the best for you, but seems simple enough)
http://www.codevba.com/office/loop_f...m#.WNcknLi1vio
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.