Export from Access Report to Excel datasheet

  • Thread starter Thread starter Anatoly Kurilin
  • Start date Start date
A

Anatoly Kurilin

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

Thanks in advance,
AK
 
Anatoly said:
Hi, is there any way of exporting an Access report to a Microsoft Excel
datasheet?
Click to expand...


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

'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
 
Back
Top