* .mdb文件具有相同的结构，需要在VB或MS Access中组合程序 [英] *.mdb files with same structures, Need combining program in VB or MS Access

问题描述

我在6个文件中名为admission.mdb，在单独的文件夹中，C：\ Adminmin \ admission.mdb，C：\Admin_2 \ admission.mdb，C：\Admin_3 \ admission.mdb， C：\ Admin_4 \ admission.mdb，C：\Admin_5 \ admission.mdb，C：\Admin_6 \ admission.mdb。


我需要组合它们并存储在C：\ Admin文件夹中有admission.mdb。


我需要VB程序或MS Access代码。


请尽早做好。


感谢你，

亚瑟。

I have 6 files with the name admission.mdb in seperate folders, C:\Admin_1\admission.mdb, C:\Admin_2\admission.mdb, C:\Admin_3\admission.mdb, C:\Admin_4\admission.mdb, C:\Admin_5\admission.mdb, C:\Admin_6\admission.mdb.

I need to combinine them and store in C:\Admin folder has admission.mdb.

I need a VB program or MS Access code.

Please do the needful at the earliest.

Thanking you,
Arthur.

推荐答案

你需要做一次，还是设置一些可以在以后再做的东西？


对于快速和脏的;方法，只需创建新数据库，并将所有表链接到它。创建一个Union查询，将表连接成一个大表。然后使用它作为附加查询的输入以附加到新表。


有关更多信息，我建议点击Access论坛 - 有更多的Access体验在那里。

Do you need to do this once, or set up something which can do it again later?

For a "quick and dirty" method, just create your new database, and link all the tables to it. Create a Union query to join the tables together into one big one. Then use that as input to an Append query to append to the new table.

For more info, I''d recommend hitting the Access forum - there''s a lot more Access experience available there.

感谢您的出色支持。我感谢您的帮助。


我需要每周一次，即周六。我需要在VB中开发* .exe文件并将其放在远程计算机上，该计算机将位于农村地区。电话连接或移动网络不可用的地方。将要使用的人对计算机的了解非常少。所以我想在桌面上创建一个快捷方式，让他们双击。

Thank you for your excellent support. I appreciate your help.

I need to do this once a week i.e. on Saturday. I need *.exe file to be developed in VB and put it on the remote computer, which will be in rural part. Where phone connections or mobile networks are not available. The people who will be using have very less knowledge of computers. So I want to create a shortcut on the desktop for them to double-click.

Ok。有什么样的结构可以复制？例如，这是一张桌子吗？或者一堆表，查询，表单，报告等？表之间的任何关系？像关系之类的东西会使事情变得复杂，因为你不能只是将每张桌子上的所有记录都转移到新的记录中而不依赖于关系。


（我可能会问一个或者两个Access专家来看看这个帖子。如果结果是他们一直在做的话，我可能只是在浪费时间去尝试解决这个问题。）

Ok. What sort of structure is there, to be copied? For instance, ins this a single table? Or a bunch of tables, queries, forms, reports and so on? Any relationships between the tables? Things like relationships will complicate things a bit, because you can''t just dump all the records from each table into the new one without adhering to the relationships.

(I might ask one or two Access experts to take a look at this thread. If it turns out to be something they do all the time, I might be just wasting my time trying to work it out).

这篇关于* .mdb文件具有相同的结构，需要在VB或MS Access中组合程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！