Exporting table with Subdatasheet to Excel

[Scott Golden]

Is there a way to export a table with a subdatasheet from Access, to Excel,
and keep the subdatasheets info in Excel?

 

[John Nurick]

Hi Scott,

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

 

[Norbert]

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.

I hope this helps
Norbert

 

[Norbert]

A2EE.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.

Best regards
Norbert

 

[norbi]

Scott Golden wrote on 12/18/2007 16:32 ET

Is there a way to export a table with a subdatasheet from Access, to Excel
and keep the subdatasheets info in Excel

If you want to export table with subdatasheet from Access to Excel, and kee
th
subdatasheet's info Excel, you need to use the Access add-in 'A2EE.mda'

This add-in has been developed for exporting

- table with subdatashee
- query with subdatashee
- form with subdatashee
- form with subfor

from Access to Excel, while keeping data from both mother and child objects

You may find details and examples on
http://www.limbersti.cz/A2EE

B
Norbert