Action queries - appending fields to various tables

Nevy

Registered User.
Local time
Today, 02:33
Joined
May 31, 2005
Messages
31
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.
 

Users who are viewing this thread

Back
Top Bottom