S
Scott Golden
Is there a way to export a table with a subdatasheet from Access, to Excel,
and keep the subdatasheets info in Excel?
and keep the subdatasheets info in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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.
I hope this helps
Norbert
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
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
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
N
norbi
Scott Golden wrote on 12/18/2007 16:32 ET
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
If you want to export table with subdatasheet from Access to Excel, and keeIs there a way to export a table with a subdatasheet from Access, to Excel
and keep the subdatasheets info in Excel
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