Im****t/Ex****t Excell files into Access

I have roughly 500 invididual Excel files that are sent to me via the IT 
department.  Each file has roughly 5 - 10 thousand lines on them.  What I
am 
wondering is, is there a Access VBA Macro that I could use to in****t each
one 
of these 500 Excel files into a Access database while looping through them
in 
one Excel directory while I continue to do other things?  The person that
did 
this last spend a day or so just im****ting them into Access and appending 
them into one file. The final Access file contains apprsoximately 2.5
million 
records.

Thanks
Frank