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])
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])
把SQL Server 作用發布端,Access97作用訂閱端,采用合并複制