Exporting access report/query to excel

[siddharth147]

Hi,
I have a situation that I cannot find a solution.

I'm designing and maintaining an MS access database that has a form to
display a snapshot of data group by a parent and its subsidiaries on a
particular date.

A report needs to be created in access which is easy. However this
report needs to be exported to excel while maintaining the report
formats (colors, font, etc)

One solution would be to create a query in access and export it to an
excel worksheet. I can then create an excel worksheet with same formats
link cells in the "query worksheet". This is okay if the number of
rows/records are the same. However in my db a parent can have any
number of subsidiaries.

Also the data (market value, total revenues, etc) needs to be grouped
by subsidiaries.

Any suggestions?

Siddharth

 

[John Welch]

Why exactly do you need an access report to appear in Excel?

Are you wanting just a "picture" of the report as an object on an Excel
worksheet, or are you thinking that somehow a user is going to work with the
numbers in the report?
-John

 

[siddharth147]

If I just want a "picture" of the report then I can print to pdf format
which all users have access to. The end user is going to work with the
numbers in the reports.