Transferspreadsheet with drill-downs?

[projecttoday]

Is there any way to export data from Access to Excel with drill downs in the result? I've tried exporting a datasheet with a subdatasheet on it but the subdatasheet was not included in the resulting spreadsheet. I also tried exporting an Access pivot table and that didn't work. (In Excel drill downs are done with pivot tables, I think. I want to create a spreadsheet within Access and then have it appear in Excel with drill downs.)

 

[Guus2005]

You have to create single line records for every drill down resulting in a single dataset to export to excel. You'll get a lot of redundancy but that shouldn't concern you.
Now create the pivot table you desire.

What i do is: I create an Excel Template which contains a datasheet (which will be hidden) and a sheet with the pivottable. Add a little bit of code to refresh the sheet with the pivot table on it when you activate the sheet.
When you export the data to the template you are prompted to enter a new name of the workbook.
When you open the new workbook, you immediatly see the pivottable.