Export to excel.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
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.


Is there a way to export a report to excel.

Floyd
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Peter R. Fletcher ...
Reports do not
generally have a structure that would "fit" a spreadsheet format.
Click to expand...

The reporting tools I've used have an 'export to Excel' facility e.g.
Crystal Reports.

Jamie.

--
 
Floyd said:
Is there a way to export a report to excel.
Click to expand...


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.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top