I want combine two tables in access 2007

Asked By mariannebford 10 points N/A Posted on - 05/01/2013

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?

• Status: Open
• Question Views: 882
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Page Layout Software

Answered By Burton Studebaker 0 points N/A #141333

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.

About Burton Studebaker

Questions
4

Answers
76

Best Answers
49

• Vote Up 0 Vote Down

• Posted on - 05/06/2013
• Question Category: Page Layout Software