Microsoft Access Tutorial : How to Create an Append Action Query in Microsoft Access

[loti042000]

Hi, is there any way on how to copy a data in a table to another table by placing it into specific row? because I created 2 tables, one is an ordinary table which has a list of name, nationality, room no. etc. well lets call it (table1). and I have another table which I called it Master database table which has a list of room no., the thing is I want to copy the data from (table1) such as names, nationality etc. into specific row which the correct room no. is located in Master database table.