AFAIK that can't be done directly. Instead, consider one of these:
1) create a query that returns the information that would be in
table+subdatasheet and export that.
2) create a (very simply laid out) report using a query like that in
(1) as its source, grouped and sorted to give the result you need;
then export the report.
On Tue, 18 Dec 2007 13:32:00 -0800, Scott Golden <Scott
Hi
John is right.
This can't be done directly.
The way he suggest would most probably work, though it would be quite difficult to fine-tune for your specific needs.
Fortunatelly there is an easier way.
You can use the MS Access add-in called "SubdatasheetsAndSubformsAccessToExcelExporter.mda", of which I am the author.
I had the same dilemma described in this thread and as couldn't find anything else, I created this add-in that exports datasheets (tables or queries) with subdatasheets from MS Access to MS Excel.
MS Excel export created with this add-in is a virtual replica of MS Access datasheet & subdatasheet.
No information is lost and it even looks similar as in MS Access.
To find out more just google for SubdatasheetsAndSubformsAccessToExcelExporter.mda.
Hi,
a new version of above mentioned Access add-in has been released.
It's name is 'A2EE.mda' (which stands for Access To Excel Exporter) and it exports following MS Access structures to MS Excel:
- Table with subdatasheet
- Query with subdatasheet
- Form in datasheet view with subdatasheet
- Form with subform
The result of export is that data from both parent (datasheet or forms) and child (subdatasheet or subform) get exported to MS Excel while keeping the drill-down view.
You can export:
- either all parental records together with all related child's records
- or only current parental record (the one with cursor) with all its related child's records
Subdatasheets and subforms exported to Excel can thus be shared with non-Access users.
As web links can't put on this forum, I can only recommend to search for 'A2EE.mda' in your Internet search engine which will provide you with download link and other details.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.