From Access To SQL2005....

[DLu]

Hi:

Is there a way to sync a Access 2000 MDB table A data changes(A/D/C) to a SQL2005 DB table A? (upgrade the .mdb to SQL is NOT an option....)

Trigger? Don't think Access support .mdb table trigger...
Replication?

What is the best way?

thanks
-D

[rmiao]

I think ssis is the only way in this case.