I need to extract the exact same items that a file search finds and parses - file name, full path (without file name) and date - and send these items to sql to populate a simple 3-field table.

We have a directory that is updated daily and I need a sql table that reflects the updated list of files, folders, and dates - this information is used to provide easy access to the files through a simple web interface. The directories are not always the same, and the depth of the sub-directories may change also.

This needs to be an easy procedure which can be run as a timed procedure on a pc at night - with absolutely no interaction from a person.

Does anyone have any ideas?