Hi, I want to import an xls file in access. So I decided to import it in a temporary table, then from there, I would move them in my access structure.
I know how to append a field using the action query. But, I don't know what to do when a reference needs to be inserted in the table.
For example, I have :
TempTable:
Model
Name
IP
Quantity
and I have:
Printers:
PrinterID
ModelID
Name
IP
and I have:
ModelTypes:
ModelID
Model
Now how would I append Name and IP to Printers, since I need to insert ModelID.
I know how to append a field using the action query. But, I don't know what to do when a reference needs to be inserted in the table.
For example, I have :
TempTable:
Model
Name
IP
Quantity
and I have:
Printers:
PrinterID
ModelID
Name
IP
and I have:
ModelTypes:
ModelID
Model
Now how would I append Name and IP to Printers, since I need to insert ModelID.