ACCESS database and SQL SERVER data synchronization scheme

mondory

An existing system uses two sets of databases, namely ACCESS and SQL SERVER.
Is there any way to make the two data automatically update the data regularly and save and synchronize!

小老鹰

If you process in Access, use linked tables or transfer queries, you need to handle the timing processing yourself.

If the job is processed in SQL Server, OpenDataSource, OpenRowSet, linked server, etc. are all available.

allenlb

You can use the dts function that comes with sqlserver.