• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 685
  • Last Modified:

Access Report - Keep formatting out to Excel

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!
0
cozmo_troll
Asked:
cozmo_troll
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In general no you cannot keep the formatting with the standard Export features of Access. If you need to maintain the formatting, you can either create a Template in Excel, and then fill that Template from Access, or you can automate Excel from Access, and open your workbook and fill and format it as needed.
0
 
Helen FeddemaCommented:
As Scott said -- both methods are covered in my Working with Excel ebook.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now