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 derfloh 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
Joined
Feb 8, 2004
Messages
30
Location
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

Avayacoolstuff
  • Locked
  • Question Question
MS quick query question
Replies
1
Views
560
PatrickRoggers
PatrickRoggers
BxWill
  • Question Question
MS EXCEL 2016 LINE CHART NOT DROP TO ZERO - USING NESTED IF AND COUNTIF
Replies
1
Views
99
combo
combo
S
  • Locked
  • Question Question
MS Project - how to add a new task into an existing baseline
Replies
0
Views
460
selazar
S
Bijugate
  • Locked
  • Question Question
Excel update question
Replies
0
Views
851
Bijugate
Bijugate
Snirt
  • Locked
  • Question Question
MS-Office 2013 Excel Issue
Replies
1
Views
615
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top