Export Report ACCESS vers Excel

[herverob]

Hi all,

I would like to Export a REPORT from ACCESS into XL. I am not talking about a Table or Query but a Report already formatted in ACCESS.

Anybody to help me ?

Regards

Herve

 

[DJkarl]

Hi all,

I would like to Export a REPORT from ACCESS into XL. I am not talking about a Table or Query but a Report already formatted in ACCESS.

Anybody to help me ?

Regards

Herve

Try the OutputTo method

Docmd.OutputTo acOutputReport ,"ReportName",acFormatXLS,"C:\XlFileName.xls"

be warned however that when you open your report in Excel it may not look like it did in Access, Excel can't really deal with spacing the same way a text file or an Access report can so it tries to do things the only way it knows how. It is generally not a good idea to export an Access Report into Excel for this reason.