Exporting report to EXCEL

[rmunteanu]

Hello
I have a problem with a report when exporting to excel. (in ACCESS 2007).
When outputting the report to excel it looses it's formats. For example the grouping becomes heading and does not look like the original report anymore.
I attached an image of the report (in ACCESS) and an image after export.
I need the export to keep the same format as in ACCESS.
Can you help me?
Thanks.

 

[boblarson]

Exporting to Excel does lose formatting. If you want a specific formatting, you will need to use the Excel Object Model to do the formatting. It can be a fair amount of coding depending on what you need to do.