Quick Access to Excel Question

[cross5900]

I am needing to know how to get an access report to export to Excel in the format I want, right now when I do it... it just doesnt look very clean. Is there a way to set it up to make the colums already spaced out and whatever else I want to do with it everytime I export it?

 

[Vassago]

The easiest way, and I use that term loosely, is to create a template in Excel and reference it in Access when Access exports it. The best way I know of is to not actually export the report directly into Access, but to export the query that the report uses and then use the Excel template to format the data you send. Unfortunately, it's going to take Excel coding to get it just right.

Access reports just are not as user friendly as they could be.