Adding constant value to import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing table into a child table through a macro. Import happens for each row in the parent table individually
 
Hi Rajesh,

I'm not sure I understand you. If I'm right, you need to link the table
rather than import it, then use an append query to put the data from the
linked table into the child table, using a calculated field (e.g.

KeyID: 99

) to generate the key value for this group of child records.
 
Back
Top