Exporting Report to Excel

[Pete]

We recently installed Access 2007. I cannot export reports to Excel. The
Excel icon is not "highlighted" when I try to export. I've tried right
clicking on export with the same results. I can export to Word, html, txt,
etc., but not to Excel. I never had this problem in earlier versions of
Access and the on-line Help clearly says that I can export a report to Excel.

I think I'm missing something simple. Any ideas?

Thanks,
Pete

 

[Mem Phiz]

We recently installed Access 2007.  I cannot export reports to Excel.  The
Excel icon is not "highlighted" when I try to export.  I've tried right
clicking on export with the same results.  I can export to Word, html, txt,
etc., but not to Excel.  I never had this problem in earlier versions of
Access and the on-line Help clearly says that I can export a report to Excel.

I think I'm missing something simple.  Any ideas?

Thanks,
Pete

Hey Pete,
I have the same question. Did you figure this one out? Do please let
me know.

Regards,
Thanks,
M

 

[DemanBOA]

Hey, I have the same problem and found the aswer from an MSFT person in a
seach. I have attached the results.
Subject: Re: Cannot export Access 2007 Report into Excel 4/30/2009 8:32 PM
PST

By: Arvin Meyer MVP In: microsoft.public.access.gettingstarted


And here's a direct link to it:

http://www.microsoft.com/downloads/...18-79EA-46C6-8A81-9DB49B4AB6E5&displaylang=en
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

The ability to Export to Excel in Access 2007 has been re-implemented in
Service Pack 2 which was just released this week!

Details here:
http://blogs.msdn.com/access/

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx