Copying and Pasting from one table to another

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

Guest

As explained in previous questions today, I have several tables with names,
addesses, phone numbers, etc. I would like to create one large table with the
contents of each of the various tables. How do I copy the records from one
table and paste them into another table?
All of the records have the same format, a first name, last name and phone
number--just 3 columns
 
Thank you for your quick response. Yes, Edit-->Paste Append did work.
However, I still would like you to tell me how to do an append query in this
case. Thanks again.
 
How far did you get with creating an append query? Start by creating a
select query with your "source" table. Add the appropriate fields to the
grid and change the query to an append query. You will be asked which table
you want to append to. Select your "target" table and match the field in the
Append To row of the grid.
 
Thank you. This is probably the best solution for other problems. I am
still studying Access and Append queries are on a future agenda.
 
Back
Top