I have 4 Excel worksheets that has a lot of data saved in them and I want to import them to Access 2007 but when I tried to do that, I got four different tables but I managed to make it two. I want to combine two tables in access 2007 if possible so that I can have it in just one worksheet. Is that possible?
I want combine two tables in access 2007
Â
Good day Mariannebford,
Â
I will help you out in simple steps how you can merge tables in Access 2007.
Â
The first thing you need to do is to open the program Access 2007 and open the file that has the tables that you need to merge.
Â
Create a new tab by clicking on CREATE and choose QUERY DESIGN.
You need to double-click the table that you want to merge which is going to be your source table. Click on the CLOSE button and you will notice that particular table is at the top part of the designer query.
Â
Find the asterisk (*) at the top of the table list fields to select all of the table fields. You need to put it to the query design grid which is at the bottom of the designer query.
Â
Select HOME and click DESIGN VIEW. Choose APPEND. Click on the CURRENT DATABASE. In the TABLE NAME box, now select the target table and choose OK.
Â
The last step is to for you to click on the RUN button and just hit YES to run the query and append the data and you're done.
Â
Best of luck.
