Export from Access Report to Excel datasheet

[Anatoly Kurilin]

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

Thanks in advance,
AK

 

[Marshall Barton]

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.

 

[Jeff Boyce]

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

 

[Anatoly Kurilin]

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?

 

[Jeff Boyce]

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