Exporting Subdatasheet

[mdjks]

I have a query that is working exactly the way I want it to in Access 2000. Each record has 1-8 possible descriptions and so I used a subdatasheet to list them. My trouble comes when I try to export this to Excel. The subdatasheet information is lost.

Is there any way to get this out to Excel? I had someone suggest OLAP but I am unfamiliar. If OLAP is the way to go I can research how to do it but if there is an easier way, that would be great.

Thanks in advance.

 

[Norbi]

If you want to export data from Access query with subdatasheet to Excel sheet without loosing data from subdatasheet, you will need to use 'A2EE.mda' access add-in.
AFAIK this is the only tool that can do this.
Best regards
Norbert