office link feature to excel in Access 2007

[Kim]

Is it possible to Export an Access 2007 report to Excel? It was so easy in
Access 2003 to just go to Office LInks > Analyze with Excel. Is there a
comparable feature? The only way I can find is to export as an xml file.
Excel is not an option. Then you have to open the file as an xml file in
excel. Exporting to Excel is an option with tables and queries, but not
reports.

 

[boblarson]

There is no built in way to export reports to Excel, as you've found.
However, you CAN use the Excel COM Object model to do it. See here for an
example:

http://www.access-programmers.co.uk/forums/showpost.php?p=541168&postcount=2
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________