Access report exported into excel

C

confused

Hello;
I need to know how to export an access report into excel.
Is there a link with sample code I can view?
 
K

Klatuu

You can use the OutputTo method, but don't expect the spreadsheet to look
like the report. It is usually better to just export the data to excel
rather than go through a report.
 
C

confused

You can use the OutputTo method, but don't expect the spreadsheet to look
like the report.  It is usually better to just export the data to excel
rather than go through a report.
--
Dave Hargis, Microsoft Access MVP





- Show quoted text -
Click to expand...

Thanks for the help; I did not relize that all I really needed to do
was have the print preveiw toolbar visable for the report(s); can then
use the officelinks for excel.
 
Top