|
|
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.
|
|
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" <broncojim[ at ]discussions.microsoft.com> wrote in message
news:8EE48390-31E8-4F7F-B196-3ACB5B0F214A[ at ]microsoft.com...
[Quoted Text] >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,
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
"Jeff Boyce" wrote:
[Quoted Text] > 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" <broncojim[ at ]discussions.microsoft.com> wrote in message
> news:8EE48390-31E8-4F7F-B196-3ACB5B0F214A[ at ]microsoft.com...
> >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,
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" wrote:
[Quoted Text] > 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" <broncojim[ at ]discussions.microsoft.com> wrote in message
> news:8EE48390-31E8-4F7F-B196-3ACB5B0F214A[ at ]microsoft.com...
> >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.
>
>
>
|
|
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
"broncojim" <broncojim[ at ]discussions.microsoft.com> wrote in message
news:77DA5C9E-8265-4F90-855C-2A6D3865CB9E[ at ]microsoft.com...
[Quoted Text] > 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" wrote:
>
>> 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" <broncojim[ at ]discussions.microsoft.com> wrote in message
>> news:8EE48390-31E8-4F7F-B196-3ACB5B0F214A[ at ]microsoft.com...
>> >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.
>>
>>
>>
|
|
|