View Single Post
 
Old June 12th, 2012, 03:18 PM
Norbert Norbert is offline
Registered User
Points: 6, Level: 1
Points: 6, Level: 1 Points: 6, Level: 1 Points: 6, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The most elegant way of exporting subform's data to Excel, I am aware of, is with use of MS Access add-in 'A2EE.mda'.
This add-in has been developed exactly for the purpose of exporting data from Access to Excel.
It can export data from both form and subform all at once and show them all in Excel in original Access-like drill-down structure.
You may find more details on:
http://www.limbersti.cz/A2EE/

Rgds
Norbert