Exporting table with Subdatasheet to Excel

  • Thread starter Thread starter Scott Golden
  • Start date Start date
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?
 
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
 
Back
Top