Export to Excel

[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?

 

[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

 

[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.

 

[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

 

[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.

 

[patti]

i ran across this solution to export to excel.

http://blogs.msdn.com/sajoshi/archi...unctionality-for-a-report-in-access-2007.aspx

my pc is currently having conniptions and i have not had time to try this
yet. Maybe it will help all who really really really wish MS had not done
away with the option.

if anyone knows of anything else, please do post here.

patti