Access Report to Excel

[Guest]

Please help me to export a Access Report to Excel (XP) if
someone know how to do it

 

[Douglas J. Steele]

See whether the OutputTo method does what you want. For a report, it would
be something like:

DoCmd.OutputTo acOutputReport, "MyReportName", acFormatXLS, "C:\My
Documents\Report.xls"

 

[njwqx@comcast]

Doug or any other Access MVP:

I know how to export Access table/query to Excel workbook
by using either (1) "DoCmd.OutputTo,,..." or
(2) "DoCmd.TransferspreadSheet, ...", but don't what's the
difference of those 2 methods. Are they exactly the same?

I can write code to export 2 tables (or queries) from an
Access mdb file to 2 Excel workbooks, but can't export
them to a same Excel workbook. Is there any way to do so?

Weiqin Xie

 

[Douglas J. Steele]

I believe there are some differences between the two, but I don't have any
details at my fingertips.

I tend to use Automation when communicating between Access and Excel. Take a
look at http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"
for a simple example.