如何让同一服务器上的SQL2000和ACCESS7中数据库部分资料保持同步?.txt

USE SQL SERVER Jobs!
Command:
INSERT INTO [TableOfSQL] ([ID],[F1],[F2],[F3])
SELECT [ID],[F1],[F2],[F3]
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=\..\XXX.mdb')...[TableOfAccess] AS T1
WHERE [T1].[ID] NOT IN (SELECT [ID] FROM [TableOfSQL]


使用Replication
把SQL Server 作用發布端,Access97作用訂閱端,采用合并複制

posted on 2006-04-26 17:30    阅读(340)  评论(0编辑  收藏  举报

导航