Join Access tables - how it works

In this practical tip, we will explain how to assemble Access tables in just a few steps.

How to merge Access tables

• Open the Access database that contains the table you want to merge with another.
• Make sure that the data types of both tables are compatible. For example, if the first cell in the source table is a number field, the corresponding cell in the target table must also be a number field.
• Click "Create" in the menu and select "Query Design". A new window opens that shows you all available tables.
• In the menu, select the table whose data you want to copy. Then click on "Add" and then close the window.
• You will see a new data set in your query design. Here you can click on the asterisk at the top of the list. This will automatically insert all the data into the design.
• If you now click on "Execute", a table with the data is displayed.
• If you are satisfied, you can switch back to "Design view" by clicking on "View".
• Click here on "Attach" to open the corresponding menu.
• If the target table is also in the current database, simply select the correct table under "Table name".
• However, if you want to merge this data with a table in another database, click on "Other database" and select the desired database via "Search". Then select the correct table name.
• To preview the changes, click "View" and select "Datasheet View".
• If you are satisfied, you can switch back to "Design view" and merge the tables by clicking on "Execute".