I require a small program to do the following.
Look at all the folder names that are in a directory called input and all sub directories thereof
The first 11 characters of the folder name is a social security number
Compare that number to a field in an access database " index ss" where the ss number resides.
Any folders which have ss numbers that are not found should be moved to a folder which the program creates called called invalid... with the respective sub-directories and their contents . A log file indicating only invalid numbers should be generated and also placed in that invalid folder and respective sub directories. The database is in the db folder ..Attached is the input and output files required. The program should be virtual. the db folder and input folder will be in the same directory.
Here is sample input and output with the index ss mdb