Hi,
There is an Access add-in called 'A2EE.mda' that can do this - it exports Access datasheets with subdatasheets to MS Excel so that both levels (datasheet and subdatasheet) get exported to Excel in drill-down view.
There are a lot of configuration option in user interface of this add-in...