Sync Ms access to sql

[bannumails]

hi all



i am trying to replicate some tables from access 2010 to sql and i managed to do it but how can i keep these tables in sync.

on the production data comes to Access Db and i need to pull it to Sql.

please advise

thanks in advance.

[ranman256]

Link in the SQL tables ,then run queries to add/update the data.

[bannumails]

Hi there
i am not good at this access database if u dont mind can u please add some articles explaining me how to achieve this.

thanks