UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Two Tables With Same Structure, Access 2016    
 
   
Bill T
post Dec 16 2017, 10:10 AM
Post#1



Posts: 79
Joined: 12-June 10



I have 2 tables with the structure the same, one table has over 5000 records and the other nearly 2000 records. The records in the smaller table are also present in the larger table but the data in the smaller table has more information in several fields. What I want to do is somehow merge the smaller table into the larger table without duplicating these records but adding the extra information.

I have used a query on these two tables and produced the desired result. Can I just copy the query results and paste into a new table or should I make a new table through the query?

Thanks

Bill

--------------------
Bill Tweedy
Go to the top of the page
 
GroverParkGeorge
post Dec 16 2017, 11:06 AM
Post#2


UA Admin
Posts: 32,357
Joined: 20-June 02
From: Newcastle, WA


"Can I just copy the query results and paste into a new table or should I make a new table through the query?"

Either way would work, but I would probably go with the latter, using a make table query because it would be more easily repeatable if something goes wrong.

And, that, of course brings up an important point about making a backup before you begin.

--------------------
Go to the top of the page
 
Bill T
post Dec 16 2017, 11:20 AM
Post#3



Posts: 79
Joined: 12-June 10



Many Thanks,

yes I always have a few backups on different devices and always work on a copy of the database first

Have just copied and pasted into a new table and then queried the old and new tables for any errors.

Bill

--------------------
Bill Tweedy
Go to the top of the page
 
GroverParkGeorge
post Dec 16 2017, 11:27 AM
Post#4


UA Admin
Posts: 32,357
Joined: 20-June 02
From: Newcastle, WA


Continued success with your project.

--------------------
Go to the top of the page
 
Bill T
post Dec 16 2017, 02:14 PM
Post#5



Posts: 79
Joined: 12-June 10



QUOTE
Continued success with your project.


Many thanks for those kind words.

Bill

--------------------
Bill Tweedy
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th April 2018 - 10:23 PM