Export from Access Report to Excel datasheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anatoly Kurilin - 19 Dec 2006 18:58 GMT

Hi, is there any way of exporting an Access report to a Microsoft Excel
datasheet?

Thanks in advance,
AK

Reply to this Message

Marshall Barton - 19 Dec 2006 19:14 GMT

>Hi, is there any way of exporting an Access report to a Microsoft Excel
>datasheet?

Well, you can try using the Tools - Office Links - Analyze
It With Excel menu item.

But, that doesn't always work out the way you want. A more
usable result can almost always be achieved by exporting the
query that you are using for the reort's record source.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Jeff Boyce - 19 Dec 2006 19:16 GMT

Anatoly

In the standard "Report" Toolbar, there is an "Export To" button. You can
choose to export to Word or to Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Hi, is there any way of exporting an Access report to a Microsoft Excel
> datasheet?
>
> Thanks in advance,
> AK

Reply to this Message

Anatoly Kurilin - 19 Dec 2006 20:00 GMT

Thanks for the tip, but when I tried to do that I got a message: "The
formats that enables you to output data as a Microsoft Excel, rich-text
format, Ms-Dos text, or HTML file are missing from the Windows Registry."

What should I do to setup these formats in the Windows Registry?

> Anatoly
>
[quoted text clipped - 11 lines]
>> Thanks in advance,
>> AK

Reply to this Message

Jeff Boyce - 19 Dec 2006 20:19 GMT

Anatoly

'Fraid I can't help you there, no experience. Have you tried posing the
error message to Google.com to see what comes up?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Thanks for the tip, but when I tried to do that I got a message: "The
> formats that enables you to output data as a Microsoft Excel, rich-text
[quoted text clipped - 17 lines]
>>> Thanks in advance,
>>> AK

Reply to this Message