use bi if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Area001]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Area001]報錯,為什麼? select * into area001 from openrowset('Microsoft.Jet.OLEDB.4.0','C:\ZIPDATA.MDB';'Admin';'',Area)select * from area001 where area001.areaCode not in (select area.areacode from Area)Server: Msg 446, Level 16, State 9, Line 8 Cannot resolve collation conflict for equal to operation.
上传数据时将当前所有标记值为0 的标记update为1
这样就可以区分哪些是新数据了。
使用SQL语言自己写
这样比较好控制
自己写程序实现,反正ACCESS与SQL之间的数据传递也不是很麻烦.
自己处理也可以对同步做控制
ACCESS里可以将表直接连接到SQL SERVER。
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Area001]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Area001]報錯,為什麼?
select * into area001 from
openrowset('Microsoft.Jet.OLEDB.4.0','C:\ZIPDATA.MDB';'Admin';'',Area)select * from area001
where area001.areaCode not in
(select area.areacode from Area)Server: Msg 446, Level 16, State 9, Line 8
Cannot resolve collation conflict for equal to operation.