Access Report to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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"
 
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
 
Back
Top