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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merging two tables

Status
Not open for further replies.
dabones99

dabones99

Technical User
Oct 4, 2002
20
US
I have two tables that may or not have identical records (both with the same index). Is there a way in Access that I could merge both tables while eliminating any duplicates, or just update the record if is found in the other table??

Thanks
 
Sort by date Sort by votes
If the two tables have identical columns then create an append query to import the data into the other and the primary key index will prevent any duplicates being appended

Savil
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
406
dhookom
dhookom
lameid
  • Locked
  • Helpful tip
Richtext Format in tables - Default vs. Embedded font...
Replies
0
Views
331
lameid
lameid
lameid
  • Locked
  • Question
Richtext Format in tables - Default vs. Embedded font...
Replies
2
Views
339
lameid
lameid
puforee
  • Locked
  • Question
6 linked tables. View All, and change data
Replies
9
Views
416
Darrylles
Darrylles

Part and Inventory Search

Sponsor

Back
Top