Using an Append Query in Microsoft Access to Add Records to a Table

If you want to add a copy a bunch of records from one table to another, the best way to do it is with an Append Query. Whether you've just imported some new customer records, or a client gives you their product sheet in Excel, or anything along these lines, you can use an Append Query to get them into your existing Access tables. This video will show you how.

PRE-REQUISITE:

LEARN MORE:

RECOMMENDED COURSES:

LINKS:

BECOME A MEMBER:

ADDITIONAL RESOURCES:

KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Append Queries, Append Query, Add records to a table by using an append query, What is an append query, Why would you use an append query, Creating an Append Query, How to Append Data, How To Make An Append Query

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[Jojosmith]

thank you very much Richard for being the best teacher as always. thumbs up from the beginning 👍

[jeanellelondeskapa]

Learned more on your channel than I ever did in Lectures. Thank you

[katherandefy]

You are brilliant! Helping a poor student here.. me 💯🙏🏼 sending cuppa joe when I get paid. I watch these all the time. I click like been subbed for weeks. Making Access fun, Rich!

[zbKawi]

Now, if I could just append your knowledge base into my head, but in the meantime thanks for time & effort

[stephenbeswick]

Hi Richard excellent Vetrinary video again steve

[akokohjoel]

Mr rost when ever i append it duplicate the values/amount, so what can i do so that amount/values will not duplicate?

[lem]

How can I append multiple fields to one field?

Field 1, field 2, field 3
Append to: newfield1

[AvalanchePerformance]

i appended the same table like 12 times because i thought it wasn't working. turns out, it doesn't visually update if the table you're trying to update is open lol.

thanks for the video.

[badmustunde]

how to create student report card software in Ms Access

[ssdusd]

Greate!, but for example if you have Excel sheet has DocumentT linked 1:M with IdsT
and the Excel sheet has Document Column and IDs Column together, I want split them to append them to 2 different tables at the same time
how can I append column Document to DocumentT and column IDs to IdsT?
I mean how can we append to Normalized tables?

[taraconti]

What if the fields don't match up in both tables? can you still append to the table? For example new lead table has a field that you need included in original customer table. help! :)

[Angko]

Can you teach multi-table Append(3tables)?

[joakimsfunandlearningchann]

Hi, i have a project on the same topic. I was trying to update the shipping date, unit cost and Add and email. Using append my data didn't update. I don't know what's the error is.

[tutsecret]

It's sad that when there is dlookup with after update that works when clicking, or selecting the country and the RaceGrrp populates on each row at a time, but when importing or appending countries, clients, etc, the column RaceGrp does not populate. And then I have to go back to excel and set up the Xlookup to get the RaceGrp and then import/append. It's ridiculous that we have to use excel to supplement Access.

[gonefishing]

Saved my rump again. I did this once. Forgot how....

[akokohjoel]

Mr rost, while watching this video I observed that your ms access have dataverse. Pls can you teach us how to use it?

[malcorub]

Is there ever a time to use "External Data > New Data Source > Excel > Append a Copy of the records to table: " over the Append Query?