Data Migration

[Anon]

Hi
I had the problem?
I have two differnt database
1.Exiesting database in Ms-Access
2.New Database in Ms-Sql server
I want to trnasfer the data from MS-Access(Source Table) to Ms-Sql server Database table.but once the user done any changes in MS-Access database its auto matically updata in sql server database table, here how to write the job schduling in sql server.
anybody knows pl give me the solution

[Anon]

is odbc an option here?

with this, you can have mysql as the backend
for the data in ms access aswell.