Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Acces Question

Status
Not open for further replies.
vino10

vino10

Programmer
Feb 8, 2004
30
PH
Guys,

How Can i Merge 2 tables with same columns into 1 table?
 
Sort by date Sort by votes
Backup your database.
Create a query using table2.
Select all fields.
From the Query menu, change the query to an Append query.
Append to Table1.

Save the query.
Run the query.

If all is Ok you can remove table2.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
291
Bijugate
Bijugate
Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
148
SkipVought
S
pjw001
  • Locked
  • Question
Question About Outlook Versions 1
Replies
4
Views
327
stuartjames78
stuartjames78
pmover
  • Locked
  • Question
MS Mac Office Single User License
Replies
3
Views
184
pmover
pmover
Andrzejek
  • Locked
  • Question
MS Teams zoom-in question 1
Replies
3
Views
159
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top