For exporting of 2 related tables from Access to Excel you can use A2EE.mda addin
one of the easiest way of exporting of 2 related tables from Access to Excel is by use of A2EE.mda Access add-in.
This add-in has been specially developed just for this job.
It can export tables that are in relation (mother with the child) to Excel while keeping the mother-child look.
There are many custom configuration options in the add-in.
Just search for A2EE.mda with your Internet search engine and you will see more.