Exporting table with Subdatasheet to Excel

242 views
Skip to first unread message

Golden@discussions.microsoft.com Scott Golden

unread,
Dec 18, 2007, 4:32:00 PM12/18/07
to
Is there a way to export a table with a subdatasheet from Access, to Excel,
and keep the subdatasheets info in Excel?

John Nurick

unread,
Dec 19, 2007, 1:38:05 AM12/19/07
to
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.

--
John Nurick - Access MVP

norbi

unread,
Jun 25, 2012, 2:53:29 PM6/25/12
to
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 keep
the
subdatasheet's info Excel, you need to use the Access add-in 'A2EE.mda'.

This add-in has been developed for exporting:

- table with subdatasheet
- query with subdatasheet
- form with subdatasheet
- form with subform

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/

BR
Norbert
Reply all
Reply to author
Forward
0 new messages