• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 695
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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