Hi,
you can easy export table with it's subdatasheet to Excel with use of Access add-in 'A2EE.mda'.
This add-in has been specially developed for this kind of job.
The add-in has it's own user interface and many controls that may be used in order to setup how will the export look like.