Exporting table with Subdatasheet to Excel

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?
 
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
 

Ask a Question

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.

Ask a Question

Similar Threads

SUBDATASHEET HELP 5
Export datasheet with subdatasheet to Excel 2
Subdatasheet Expand All (Format menu) 1
Subdatasheets 2
Accidentally removed subdatasheet 3
Subdatasheet Help 3
specifying which subdatasheet in Access 2003 3
Subdatasheet comes and goes 1

Top