So you’ve imported some data into your Microsoft Access database and now need to add that data to an existing table. It would be handy to copy and paste but using an append query does the trick and you can also just append specific data based on criteria.

Appending imported data is straightforward, however, sometimes the field names of the imported data don’t match those of the table you are importing into. Using the append query deals with this.

As always before doing this test out how it works on a copy of your database and remember to always backup your data.