So you are joining Access tables
- Open the Access database that contains the table that you want to with a different blend.
- Make sure that the data types of both tables are compatible. Is the first cell in the source table, for example, a numeric field, the corresponding cell in the target table is also a numeric field.
- In the menu, click on "Create" and select "query design". A new window will open, showing you all of the available tables.
- Here you can select in the menu of the table whose data you want to copy. Then click on "Add" and close the window afterwards.
- You will see a new dataset in your query design. Here you can click on the asterisk at the top of the list. So, you add all the data automatically in the design.
- Now, if you click on "Run", a table appears with the data.
- You are satisfied, you can switch by clicking on "view" to "design view".
- Here, click on "Append" to open the corresponding menu.
- If the target table is also in the current database, select "table name" is simply the correct table.
- You want to merge this data with a table in a different database, click "Other database" and select the desired database via "Browse". Then select the correct table name.
- To preview the Changes, click on "view" and select "Datasheet view".
- If you are not satisfied, you can switch back to the design view and the tables by clicking on "Run" to merge.
Access tables together
In the next tip we will explain where you can free templates for Access find.
