I would like to import a CSV file into a master database once a month. I need a report developed that will analyze that data.
The data will roughly consist of fields such as: Business Name, DBA, Address, Permit Number, Expiration Date. The 'Permit Number' will be unique to each business location & is valid for only 1 year. Because permits must be renewed yearly, the CSV file I import each month will contain nearly 99% of the permit numbers from the previous month. I need a report of the 1% of those numbers that were not previously on the list.