How to export the report to Excel and keep the same layout?

2007fld

New member
Local time
Yesterday, 17:43
Joined
May 13, 2008
Messages
3
I’m using Access 2002. I can generate a nice report in Access, with color background for the header and each section. But when I export the report to Excel, (or analyze with Excel), the nice format are lost in Excel file. Each section’s header is moved to the first few columns and no color background anymore, just plain data.

Is this common? How to make the report looks the same in Excel? Do it manually?
Thanks much!!!
 
reply

I have the same issue and write my report using a .pdf writer.
 
The simplest way to maintain the look of the report is to export in pdf format as aftershokk mentioned, or Snapshot format. If you need it to be in Excel, you'll need to use a technique called "automation", which is basically opening and control Excel from within Access. Searching for that should turn up the appropriate code.
 

Users who are viewing this thread

Back
Top Bottom