Export Access 2007 report to Excel 2007

[Kevin Larouche]

Hi,

I would like to know why I'm unable to export my Access report to Excel
format.
In Access 2003 I was able to do it perfectly.
If there is no possibility, are you planning to make an add-in or update for
this??

Thanks

 

[Carl Rapson]

Hi,

I would like to know why I'm unable to export my Access report to Excel
format.
In Access 2003 I was able to do it perfectly.
If there is no possibility, are you planning to make an add-in or update
for
this??

Thanks

I've had the same problem. As far as I can tell, Microsoft completely
removed the ability to export reports to Excel. From what I've read, you now
have to open the Record Source of the report (hopefully a query) and export
that. I have yet to see any alternatives.

Carl Rapson

 

[Cris]

Change the report to a form.
You can export a form to Excel.

 

[hlock]

I don't suppose there is an easy way to convert a report to a form, is there?

 

[Jeanette Cunningham]

hlock,
find the query that is used for the report.
Use the form wizard to crete a form based on the query.
Open the form in design view and make any changes.

Jeanette Cunningham