Report to Excel

S

simon

I have an app which I'm now using with Access 2007

With the old Access 2002 I was able to preview the report and then select
Excel to send it to
an Excell file.

Since upgrading to Access I can no longer select Excell - its grayed out
I can select text but NOT Excel

The person who wrote the app no longer works with company
How can I enable the Excel button??
 
J

John Spencer

Sorry, you can't in Access 2007. This ability was removed when Microsoft lost
a lawsuit on the ownership of the feature.

You can export the underlying query.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Please help me choose a product for the task 2
Updates for excel 2002/3 0
Automate shape report 0
Converting Data in a Report to Excel 9
Mail Merge with Excel and Word 2007 1
Converting excel to PDF, single page converts to multiple HELP! 1

Top