This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 我想把access中的数个表合并merge起来。请问有没有什么工具？说明：这些表之间存在复杂的关系，而且目标文件和源文件相应的表可能有相同的数据（replace/insert）。
-lilyba(Sunshine);
2002-12-12
(#909244@0)
-
up
-lilyba(Sunshine);
2002-12-12
(#909283@0)
-
up
-lilyba(Sunshine);
2002-12-12
(#909307@0)
-
up
-lilyba(Sunshine);
2002-12-12
(#909330@0)
-
why not simply write a query in Access?
-asdfasdf(牛牛很牛);
2002-12-12
(#909348@0)
-
表太多。而且关系复杂。用查询还不利于以后别人使用。
-lilyba(Sunshine);
2002-12-12
(#909365@0)
-
How about try to bcp data to MS SQL server, then transfer the results back to access?
-asdfasdf(牛牛很牛);
2002-12-12
(#909380@0)
-
is this what you want?
-tongcd(zombie);
2002-12-12
(#909391@0)
-
thanks. actually, i want a more powerful tool. 一个更自动化的工具。现在有一个。但是因为别人（非程序员）也要用，所以需要更多的工作。
-lilyba(Sunshine);
2002-12-12
(#909419@0)
-
You can manipulate data anyway you want. If existing action queries are not enough for you, write VBA code to do it as long as you know the logical relationship among the tables.
-1499728inc(bank);
2002-12-12
(#909851@0)
-
不知这个方法是不是笨了点：用SQL Sever，导入数据，用sql script删除重复项，再导回Access。
-liding_wang(无坚不摧大砍刀);
2002-12-13
(#913001@0)
-
哦，牛牛说过了。：）原来有人和我一样笨。
-liding_wang(无坚不摧大砍刀);
2002-12-13
(#913011@0)