How do I automate a reoccuring data load from Excel to Access?



I need to update an Access database weekly from an excel spreadsheet
generated from one of our systems... In doing so, there is some basic
transforms to do one the data before it is dumped in...
Is there an easy/good way to do that?

thanks!!
.