It will do much more than you think. Please refer SSIS in BOL for further detail.
You can also think about database import which also support Access source.
Refer following links which might be useful:
http://technet.microsoft.com/en-us/library/ms140052.aspx
http://www.sqlservercentral.com/Forums/Topic1139114-391-1.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."