Can anyone out there help me figure out how to best merge 1500 matching spreadsheets for analysis? They have the same columns, in the same folder. I have access to Access, Excel, SharePoint, Word, Informatica, Eclipse. Any other recommendations have to be free (gratis), or have a free trial that does the merging.
The purpose of this is for me to clean the data and verify quality before importing into a CRM. Which software could do that?