kohai, in that case, I would recommend using SSIS package to extract the data from Access and Excel then dump that data into a Staging table then from Staging table you take the rows into your clean table.
how often does the data from colleges come.