Export Access Report to Excel

[broncojim]

I understand there is no built-in way to export an Access report to Excel.
Before anyone asks why I want to do such a thing, it is because my boss wants
to view my reports in Excel. After getting this out of the way, does anyone
know of any code or macro that will export an Access report with formatting
to Excel?

Thanks.

 

[Jeff Boyce]

Prior to Access 2007, there WAS a way to export reports to Excel.

Access 2007 does not offer this capability.

One way to work around this limitation is to export the query that you use
to feed your report, instead of trying to export the report itself.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[broncojim]

Jeff,

I actually was a happy user of this function in previous versions. Trouble
is, my boss wants to view my reports in excel. The nice thing about access
is the one-click queries and reports. If I have to export my query, I might
as well start from scratch due to all of the totals, groups etc. Is it even
possible to write code to do this on your own? If so, has anyone done it?
If not, does MS plan on addressing this issue, since it seems many, many more
users are also dissatisfied?

Sorry for all the questions, but for each query I have to export and
reformat, I spend at least 30 minutes of valuable time reformatting it. It's
almost worth hiring someone to do that alone!

Thanks,

Jim

 

[broncojim]

Jeff,

I have used the funcionality in previous versions. Nice, wasn't it? Does
MS plan on addressing this issue? If not, can code be written to execute
this export process, and, if so, has anyone done it?

 

[Jeff Boyce]

If I understand the situation, Microsoft was involved in a lawsuit and
removed the 'export (report) to excel' as part of the settlement.

I've not seen anyone who has worked out a work-around, but keep looking! If
you find something, post back here, 'cuz there are a LOT of folks who used
that.

I had to come up with a work-around (via the export query route) for my
users, but they're used to doing all their own formatting.

I suppose, if you were very very inspired and had plenty of time/experience,
you could "automate" Excel from Access and write directly to an Excel
spreadsheet. It won't be fast or easy (unless you already do that kind of
thing for a living).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP