Microsoft Access: How to Use the Append Query

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.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast
This entry was posted in Microsoft Access, Microsoft Office, Office 2010 and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s