Append Query

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

Guest

I have multiple table that I want to get all their information into one
table. All the fields are not the same but, I want the ones that are to go
into an already existing table. Is there anyway to do this with an append
query? Thanks in advance for any help.
 
Tony said:
I have multiple table that I want to get all their information into one
table. All the fields are not the same but, I want the ones that are to go
into an already existing table. Is there anyway to do this with an append
query? Thanks in advance for any help.
Click to expand...

Sure; that's exactly what an append query is designed to do. Create a Query
based on the table which is to be the source of the data; select whichever
fields you want to copy (and don't select the others); change it to an Append
query and select the names of the fields into which you want the data to be
put. There is no requirement that the fieldnames match, but if they do,
Access will put them into the Update row by default.

John W. Vinson/MVP
 
Back
Top