Access to excel

[subs1678]

is there any way to automate the export of a Access report to excel. for example if there is a button on the report, and on clicking the button, the report should be converted to excel format. Is there any way to create this format?
Please help if there is a macro or some program

 

[PHV]

Have a look at the DoCmd.OutputTo method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[subs1678]

when i convert access report to excel, my summarized data like sum, count go to columns adjacent to where they should be. Is there any way to solve this problem.