Re: Insert records in Parent and child tables

I would bring the records into a temporary table and then use an append
query to push the parent to the parent table. Then use a union query of the
children to append them to the child table.
--
Duane Hookom
MS Access MVP

"Sujal" <Sujal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6460E0E-E89A-4D66-996B-1FCF11759F85@xxxxxxxxxxxxxxxx
I have a spread*** which contains a parent name and 3 children inames n
one
row. I want to import the data into access, I have a parent table and a
child
table, both of these are linked with parent id as a foreign key in child
table.

How do I insert 1 row of data from excel into the parent tabel and 3
records
in Child table with the parent id as a foreign key ?

Any help on this greatly appreciated!


.