Access SQL Seminar Part 2 covers Action Queries

I'd need to know a lot more about the data in order to tell you exactly how to handle it. Your question is kinda vague.

Rick, I receive an Excel file every month via download from an external cloud service.  There is one record per member, with a mixture of data types such as short text, currency, and dates.  The data is Name broken out, address, city, state, zip, and Demographics such as age, length of membership, parish, phone number, and email address. Fraternal data such as Ordained, dates of initiations, and places of service.
In building the Access database to handle the data on my side and processes I wanted to automate I ended up breaking the member's info into 5 tables, MembershipT, FraternalT, PhoneT, EmailT, and your HelperT for all the onesie twosie tables into one.

So now comes the Excel file from Supreme and up till now I have been hand-entering the member's data into the tables and find it very time-consuming.  So following along with your TechHelp videos on finding new data or changes to tables and using Append or Change queries to sync the data.  So right now I import the Excel file into a temp table and want to parse the data out to the tables.  The one piece of data that links them all is the MemID which is a short text field.

I hope this helps more than blurs things.  With your classes and Techhelp Videos, I feel I have come a long way in just 2 years, all thanks to your teaching style and the people that back you up.

Now back to the original question.  I'm wondering your thoughts on which might be easier or better to set up Append Queries for the table (Which I have started) or using APPEND into TableXYZ... (which I have also started).  I'm thinking of the queries, but wonder how to write the VBA code to run the 5 queries depending on if there is data in the Temp table to go into each Table. Possibly If then statements?

Normalizing Data

If your MemID links them all, then I would save that in each table (in addition to your autonumber PK). Then you wouldn't need VBA code to simply update records. Use update queries to update existing records and append queries to add new ones. If the MemID is indexed (no duplicates) then it will automatically disregard adding the same user twice.

Thanks, Richard and Kevin your responses are always fresh and very helpful.

One thing to consider is whether your Excel data may contain any erroneous information, and if so, how to catch it.  If you have "123 Any Street Apt A1" as an address in your Access table, and the incoming Excel file has only "123 Any Street" for that same person, missing the apartment number.  Obviously in such a case you don't want to overwrite your existing data with it.  So how do you check for things like this?  Can you count on whoever gives you the Excel file to always give you accurate data?  Even if they say yes, how far will you assume their data will always be correct, without doing any checking at your end?  These are the things that would be on my mind if I received any external data from anyone, especially data that are to replace and/or add to my existing data.  If these data involve hundreds (or more) rows every time, this can become a formidable task.

I spend a lot of time in Access Expert 14 and again in Access Developer 21 on "scrubbing" data.