<div>
As Scott said -- both methods are covered in my Working with Excel ebook.
</div>


As Scott said -- both methods are covered in my Working with Excel ebook.

<div>
<div class="content wysiwyg-content">
I have a detailed report in access that I need to export out to Excel so that some fields can be completed by another party and then forwarded on to a different group all together. It has to be Excel so it is editable (PDF won't work). When I export out to Excel, even though it says it will keep it's formatting, it doesn't. Is there a way to keep the exact look of the report (in access), is my question. <br />
<br />
Thanks!
</div>
</div>


I have a detailed report in access that I need to export out to Excel so that some fields can be completed by another party and then forwarded on to a different group all together. It has to be Excel so it is editable (PDF won't work). When I export out to Excel, even though it says it will keep it's formatting, it doesn't. Is there a way to keep the exact look of the report (in access), is my question. 

Thanks!

Access Report - Keep formatting out to Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.