Some of the uses of append query are as follows

☛ You will save time by appending data to an existing table rather than manual update.

☛ Appending files based on specific criteria is possible.

☛ If your destination file doesn’t have columns and rows you can add certain columns and rows thus ignoring the rest of them.

☛ Append can save time and labor when dealing with large database updation.