A new table glued together from parts of three other tables

[ondrejruz]

Hello. I have 3 tables in Access. I need to select part of the records from each table and create a new table from them. When I do it by copying, the resulting table is wrong. Although IDs are unique in each record. Can anyone help? Ondrej

[CJ_London]

use an append query

[June7]

Why do you need a table as opposed to just using a query? Do these tables have relationships?

Provide sample data and desired result. Either build tables in post or attach file.

[ondrejruz]

All tables have the same structure. The record has 75 fields. There's personal information in there so I can't post it.

[ondrejruz]

I have an idea that it can be done in the VB, I just need an example.
- mdb file1 opens
- mdb file2 opens
- table tab1 is opened in file1
- table tab1 is opened in file2
- tab1 is "read" from file1 in the cycle
- via INSERT, the record from file1 is "written" into tab1 from file2
Can it be done somehow?
Ondrej

[June7]

We need data structure and relationships, not real personal data.

Now you tell us these tables are in different files?

Set links to tables. Build queries.

[Welshgasman]

I have an idea that it can be done in the VB, I just need an example.
- mdb file1 opens
- mdb file2 opens
- table tab1 is opened in file1
- table tab1 is opened in file2
- tab1 is "read" from file1 in the cycle
- via INSERT, the record from file1 is "written" into tab1 from file2
Can it be done somehow?
Ondrej

No need for VB, can be done all via queries.

[xps35]

- mdb file1 opens
- mdb file2 opens
- table tab1 is opened in file1
- table tab1 is opened in file2
- tab1 is "read" from file1 in the cycle
- via INSERT, the record from file1 is "written" into tab1 from file2

You will find your answer in post #6.

I would like to point out that it is important that you give a clear description of your problem. The quoted text says something very different from the original question. No three tables here and no new table to be made. You also did not mention that there were different databases.

[CJ_London]

@xps35

You will find your answer in post #6.

Do you mean post #2?

[xps35]

@xps35Do you mean post #2?

No I really mean #6. With the knowledge of that moment, #2 was the correct answer. Now that we know that there are different databases, linking tables is an essential part of the solution. That is also mentioned in #6.