Access report exported into excel

  • Thread starter Thread starter confused
  • Start date Start date
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?
 
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.
 
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.
 

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.

Ask a Question

Similar Threads

Word to Excel: Export comments with text and line number 0
Export Data to Xls 1
ACCESS (Query) to EXCEL 3
export to excel with format 1
Cannot export Access 2007 Report into Excel 5
How to Export a query to a new spreadsheet 4
Export from Report's recordsource 1
Dump a report into Excel 1

Back
Top