使用DAO Recordsets中的数据填充Access 2000表 [英] Populate an Access 2000 Table with data from DAO Recordsets

问题描述

您好 - 感谢您阅读我的帖子。


我是VBA编程的新手，但是我已经设法做了我需要做的事情，直到现在。


我有一个Access 2000数据库（运行WinXP Pro（SP3））。


我在我的数据库中成功创建了3个记录集。我需要做的是从这3个记录集中获取数据并将它们放入表中，以便我以后可以运行报告。我能够创建记录集和包含我需要的所有字段的表，但我不知道如何将记录集中的数据放入表中。非常感谢任何帮助。

谢谢


BeckR



下面是代码我在用。

展开 | 选择 | Wrap | 行号

解决方案

BeckR，当你说你的数据存储在3个记录集中时，你是什么意思？


记录集是一个动态代码实体，它引用返回数据的东西。它不适合这种情况。通常我会假设你只是简单地提到表格，但你单独提到一个表格，所以我怀疑这是在这种情况下的解释。

Neopa


我为这种困惑道歉。


我创建了3个DAO Recordsets，它从数据库中的3个表中返回数据。然后我创建一个新表，需要包含来自3 DAO Recordsets的信息。我创建了记录集和表，但我不确定如何将记录集中的数据放入新表中。创建新表后，它将使用新表数据生成联盟计划。


谢谢Neopa



BeckR

这里还有点混乱我' '我害怕。所有四个表都是相同的格式吗？我认为它们必须是你没有提到的。


如果是这样，你想将所有三个原始表中的所有记录追加到第四个吗？

Hello - Thanks for reading my post.

I am a newbie when it comes to VBA programming, but have managed to do what I need to do, until now.

I have an Access 2000 database (running WinXP Pro (SP3)).

I have successfully created 3 recordsets in my database. What I need to do is to take the data from those 3 recordsets and put them into a table so that I can run reports at a later time. I was able to create the recordsets and the table with all the fields that I need, but I do not know how to get the data from the recordsets into the table. Any assistance would be greatly appreciated.
Thank you

BeckR


Below is the code I am using.

Expand|Select|Wrap|Line Numbers

解决方案

BeckR, what do you mean when you say you have data stored in 3 recordsets?

A recordset is a dynamic code entity that refers to something that returns data. It doesn''t fit in this context. Normally I''d assume you''re simply referring to tables, but you refer to a table separately so I doubt that''s the explanation in this case.

Neopa

My apologies for the confusion.

I have created 3 DAO Recordsets which return data from 3 tables in the database. I then create a new table which needs to contain the information from the 3 DAO Recordsets. I have the recordsets and the table created, but I am not sure how to place the data from the recordsets into the new table. Once the new table is created, it then generates League Schedules using the new table data.

Thanks Neopa


BeckR

Still a bit of confusion here I''m afraid. Are all the four tables of the same format? I assume they must be as you don''t mention it.

If so, do you want to append ALL the records from ALL the three original tables into the fourth?

这篇关于使用DAO Recordsets中的数据填充Access 2000表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！