Create Access Table based on filenames in a specified folder

[ScotWilder]

Hi folks,

I have a requirement to automatically populate a table based on the contents of a specified folder.

The file-names follow a protocol of the below -

180936-556849.doc

The extension can be different, e.g. docx or pdf, so the action would be to

1 - Find the directory
2 - Clear the access table
3 - Use code to populate the table with the split out file-name in separated fields.

So I'd need an end result that looked like -

Field Names:
URN/Comm_Number/File_Extension

Data:
180936/556849/doc

I'd found a database entitled Browsing.mdb from a user (my apologies I've forgotten his name!) but it only displays the information as a report not as an auto populate to a table.

Any help gratefully received!

 

[sxschech]

Will this link help?

List files to a table:

http://allenbrowne.com/ser-59alt.html