So I have the main form with the one record, and the subform with related records. I want to export the main form record as a header in Excel, and the subform records as rows below that. Anyone know how to do that or have an example? Thx
Export main form record along with subform records to Excel?
- Thread starter burma
- Start date
Do you use CopyFromRecordset from the Access side or from Excel? Do you have an example? Thx
Gasman
Enthusiastic Amateur
- Local time
- Today, 16:45
- Joined
- Sep 21, 2011
- Messages
- 17,406
Well if you are exporting from Access then I would have thought from the Access side?
Plenty of examples out there. Just use Google to find some.
- Local time
- Today, 08:45
- Joined
- Oct 29, 2018
- Messages
- 22,722
Yes, I do it from the Access side. Here's one example.
MS Access - VBA - Export RecordSet to Excel | DEVelopers HUT
How to Export an MS Access RecordSet to Excel using Excel Automation via plain vanilla VBA including advance features and formatting.
www.devhut.net
Thx!
I'm not really sure. I was thinking of having the main form record in a "header section" at the top, and related child records in rows below it. Like what a form/subform displays in Access. But for now, I'm just dumping the raw non-deduplicated data into Excel. Thanks
Gasman
Enthusiastic Amateur
- Local time
- Today, 16:45
- Joined
- Sep 21, 2011
- Messages
- 17,406
I would have thought it would be two CopyFromRecordSets then?
