You need a recordset then. I think they begin covering those in Access Developer 16

For Next Loops

I would like to use Loops but I need the syntax to reference the specific table.record.field(s)

That is where going through the courses come into play.

We are here to help out, not to just write individuals code.  We're glad to point you in the right direction but at some point...

If you want someone to do the work for you there is always the AccessDev.NET.
There are developers listed there that can help for a fee.

Scott, thanks for your help. The TechHelp videos have been very helpful and are a wealth of information, but I could not find one that helped me with this specific issue. There are several videos using forms so maybe I'll just change my logic and not try to modify the temp excel imported table.

Why can't you not just do some VLOOKUP/XLOOKUPS for the values in excel first
Then do an import

This may be accomplished with just an update query (no VBA needed) with the right criteria and relationships (if needed).  Sample SQL:

UPDATE PhoneRecT
SET CustomerID = DLookup("CustomerID", "CustomerT", "PhoneNum = '" & PhoneNum & "'") & ""
WHERE CustomerID Is Null

The finished table in access needs to include the customerID and the InvoiceID that are created in access. The call data that comes from a 3rd party excel sheet only has info related to the phone number. Importing the detail data associated with the phone number is easy but I need to insert the InvoiceID & CustomerID before I merge it into the access Invoice table so that the data can be referenced per customer and then per Invoice. Thank all of you very much for your comments as they have been helpful.

Import Data
Normalizing Data

Yeah, depending on the specifics, you can probably get away with a bunch of Update Queries

Wow, I did not realize what can be accomplished with DoCmd.RunSQL commands. I was able to combine all of the queries I needed into these commands and get the project working.

Thank all of you so much for your help.