Merging 2 Access Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This may be a *common* question with many threads already circulating.

But I want to take all of the fields from one table an populate the records
into the third table.

Then I want to take the matched records from table 2 (Primary Key is
Agency_Profile_Id) and populate table 3 with data (columns / field values not
already used from table 1).

My partner and I opened Access, Started a query in Design View, and Joined
the 2 primary keys. Selected ALL from both fields. But then..

What do we do next please?

Daniel
 
I did find this by searching.
"If you don't already have a third table and you are only doing this once, my
suggestion would be to create a make table query from your first table. This
will create the third table and append the records from the first table.
Switch the query to an append query. Remove the first table from the query
and then add the second table to the query. Add the fields from the second
table to the blank query grid. If the field names are the same, you should
automatically see the "Append To" fields in the grid. Then run the append
query."

Just do two *appends* if the table is existing?

The third table was just a mark-up job pasting the needed column names (not
sure of the propert/data type accuracy)...

Is append easy to do?
 
I have created the Query and I know how to change it to a Make table query.
I set it so all records come from EAP in addition to all records that match
in EAP and ACES tables. I WAS deselecting the common fields from EAP but I
think I got it backwards and I need to exclude the common fields from the
ACES table instead in my Join type. Right?

DAN
 
Back
Top