Update 2 tables with temp table

[Guest]

I need to automate the import and update process. So far I've managed to
import the data from Excel into a Temp table in Access.
Now I need to update the information from Temp table to both Table1 and
Table2, preferably via VBA or some sort of coding.
The fields for these 3 tables are:

Temp:
PO
PartNum
Rev
Invoice
Unit Price

Table1:
PO
POID
PartNum
Invoice

Table2:
POID
UnitPrice

From the TEMP table, both fields PO, and concatenation of PartNum and Rev,
are use to link with PO and PartNum in Table2. In other words, there is no
one unique identifier between TEMP and Table1.

Table1 and Table2 can be joined by POID.

I'm only maintaining this database and is not at liberty to change any
database structure.

How can I update Table1 and Table2 from TEMP table?

I've searched this post but can't figure out a solution. Any help is very
much appreciated! thanks. Samantha

 

[[MVP] S.Clark]

Using VBA and/or queries, add one record from the parent. Once you know
that's Parent's ID, then add all of the child data for that parent. Keep
in mind that some parents may exist, other's may not. Same goes for the
child data. So, plan ahead how your going to handle those specific updates.