append query

[hilmunger]

I'm not sure how to do this right, but I have a table that I want to import into an existing table. The fields are the same, however the existing table has more than the one that I'm trying to append into it. If there is a way to do this without typing in every record, I would greatly appreciate the advice.

 

[foreveryoung]

If I understand your requirements then this is an example of a sql statement will do what you want.
Just replace mybooks with the name of the destination table and title_id, title, type with the names of your fields.

INSERT INTO MyBooks
SELECT title_id, title, type
FROM titles


Is it an append query you want? Are you doing this as a one off?

 

[hilmunger]

Thanks for the advice. I figured out what I was doing wrong and corrected my query so that it would work. Bear with me, I'm new at this and am taking the self-taught approach.