I don't believe so. Tables and Queries can be exported to Excel
because there is a natural correspondence between Records and Fields
on the one hand and Rows and Columns on the other. Reports do not
generally have a structure that would "fit" a spreadsheet format.
You can try using the OutputTo method (or the main menu
Tools - Analyze with Excel), but report formatting can not
always be represented in a spreadsheet.
You would be much better off exporting the report's record
source query instead.
That's fascinating! What you get bears no relationship to the
appearance of the Report. It's sort of a combination of the source
query and some of the labels in the Report. I can't imagine why you
would want to do it, but you certainly can. BTW, it is File|Export to
Excel, not Tools|Analyze, at least in Access XP
You can try using the OutputTo method (or the main menu
Tools - Analyze with Excel), but report formatting can not
always be represented in a spreadsheet.
You would be much better off exporting the report's record
source query instead.
Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
