Well since you are using access i imagine the data is pretty small the quickest way is to truncate the table in sql and re-insert all data. Or load the table into a staging table in SQL then create an insert update script that can be called from a sheduled package that compares the two tables in sql and either inserts or updates.
Create a package that takes your data from access to a staging table in your SQL database.
Then create a step that takes the two table in SQL and runs a insert where not exists and update where the values are not equal to based on your primary keys.
Tip. Add a beginning step to clear out your staging table from your previous run. I would do this at the beginning rather than at the end this way if you need to verify records you have the data for the whole week to review it.
Well, but the access file changes every week. so i cant do the re-insert all data. your second idea is really good, can you help me with example. i am going to update every 8 hours in a day. the mdb files is getting changed every 4th day r 7th day.