Merging several tables

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

Guest

I am a new user of Access (1- 6hr course under my belt) I have 5 very large tables of part numbers that I would like to merge into 1 table to eliminate the need to perform several queries - Is there a way to do this??
 
You could use Append Queries. BUT, be sure that in doing
this, fields being appended would not violate a Primary
Key value in the "receiving table".

HTH - Bob
-----Original Message-----
I am a new user of Access (1- 6hr course under my belt) I
Click to expand...
have 5 very large tables of part numbers that I would like
to merge into 1 table to eliminate the need to perform
several queries - Is there a way to do this??
 
Back
Top