Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export to Excel with Report and Page Headers

Status
Not open for further replies.
achillese

achillese

Technical User
Jun 26, 2005
25
AU
Hi,
I am trying to export an Access data to Excel via a report and noticed that the Report Header is NOT exported, only the page headers (Field column Headers) and row data are exported.

I was thinking of a template of which an existing Excel File has a Report Header AND just append the exported Excel with the page headers and row data as done above. But I do not know how to accomplish this one.

How do you work around with this one or any better alternative?

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
470
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
497
dhookom
dhookom
Zandy12
  • Locked
  • Question
Repeat the Report Header after Page Header / Details ends.
Replies
1
Views
799
dhookom
dhookom
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
213
GPnew
GPnew
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
504
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top