Report format in Excel

[mark curtis]

Dear all,

Can anyone tell me how to get over a little problem?

When I export a report to Excel I expect to see the same format as in Access. My report is grouped by department and then year. In the deatail section I have data for months and I want to show the data from jan to dec.

Is there any help on how to create a template in excel and then send a access report or query to that template. I am after automation, where I can control the look and feel.


Thanks
Mark

 

[Chris RR]

Try this link to Dev Ashish's site, and an article called "Transferring Records to Excel with Automation: http://www.mvps.org/access/modules/mdl0035.htm

This method is some work, but once it's set up, it gives you a lot of control over the Excel formatting, and it runs fast.