Hi,
I have been working with VBA for three years for companies like IBM, MSCI and Ford Motor Company
At MSCI I created an Excel application that connects to an ftp server of a hedge fund (HFR) every night, downloads a csv file and compares its content to an SQLServer database, executes update and inserts statements based on the differences found, then it sends a mail from Outlook informing the recipients about the number of changes.
Based on the description you need something similar, but I can help you only if you are fine with the add-in created inVBA.