Export access 2010 report

cmfog

Registered User.
Local time
Yesterday, 20:11
Joined
Jun 18, 2014
Messages
21
I am trying to export my access report to excel and keep the formatting from the report so that I can edit information in my excel spreadsheet.
 
As someone who totally avoids Access Reports and creates custom Excel Reports with formatting from Excel Object Model code...
look up
DoCmd.OutputTo acOutputReport, outReport, acFormatXLS, "rpt_KPI_Monitoring.xls", True
It isn't the full format, but it is rumored to retain some.
Another method is to create a style sheet for Excel and move the data into it (lol)
http://www.rogersaccesslibrary.com/forum/topic350.html

http://www.howtogeek.com/howto/microsoft-office/export-an-access-2003-report-into-excel-spreadsheet/http://www.rogersaccesslibrary.com/forum/topic350.html

http://smallbusiness.chron.com/generate-ms-access-report-excel-file-40343.htmlhttp://www.rogersaccesslibrary.com/forum/topic350.html


There use to be a video tutorial showing options for exporting Reports:
http://www.youtube.com/watch?v=xaUyTmTUJxw
That is about all I can offer.
 

Users who are viewing this thread

Back
Top Bottom