Sync data from MS Access to MS SQL

Question

Is there any way so that whenever we insert data in Ms Access table then it will sync in MS SQL table. Table schema will be same in both database.

I have to do something so that data will sync from MS Access to MS SQL because both database are live.

Answer 1

You can write an MS SQL SSIS package to do this. Here's an article on how to set up your AccessDB as a datasource so that you can reach it from within your SSIS package (note that you'll want to read the section on Access 2003 and earlier). And if you've never created an SSIS package before, here is a simple SSIS tutorial.