Export to Excel

J

JimP

Now that MS-Access 2007 has disabled exporting a report to Excel, is there a
work around or third-party add-in to do this?
 
J

Jeff Boyce

If you find one, post it back here!

The work-around I'm working on takes the queries on which the reports are
based and exports THEM to Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

JimP

Ouch! There are a couple thousand reports in my mdb (SQL Server report
writer). I need to try to find a one-click solution.
 
J

Jeff Boyce

Jim

I have a "reports order" form I use to let the users pick which report and
which selection criteria they wish to use. I'm adding a 'one-click' button
<Export to Excel> on that form that will let them pick which report and
which selection criteria ... and send the underlying query/data to Excel.

Define 'one-click' ... one for them or one for you?!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

JimP

Thanks, I'm not sure how users use the Excel export, except to the extent
that I can duplicate the functionality of Access 2003, they shouldn't
complain.
 
Top