I have a folder full of excel files, all in the same format, but with different, and sometimes duplicate data. I need a small program to extract this data, warn if is not consistent with what is in the database, and add to the database if it does not exists. Looking at about 12 unique fields in each file and then another 50 that are essentially the same. I've attached a sample excel file, the access template that I would like filled in, and a mapping between the two.
A program where I can a) select the database, and the b) select and add each file indivisually would be fine. Adding all the files in the directory would be a bonus.