I need a report pulling program built. We deal with multiple affiliate companies and pull report everyday from each account. I need a program that can pull these CSV reports and insert into either access or excel at which point the data is normalized and then a report can be run on all of these. The goal is to automate this process for time saving as we go daily to around 15 sites, pull reports, upload and normalize in excel, then merge in access and create a report on query.
Please let me know a basic price structure and what programs you see fit to create this. A GUI would be a nice addition if possible.