Append Access report data to an excel sheet. (1 Viewer)

[ielamrani]

Hi,
I have a report gruoped by Owner that I was able to export to an excel sheet
using the following code: DoCmd.OutputTo acOutputReport, "FinalReport",
acFormatXLS, "C:\FinalRep.xls", True

It's working but.. everytime I export it, it creates a brand new report.

I would like to append data from the report to an existing Excel sheet (Name:
FinalRep)that already have these fields name.

Insured Name:
DOB:

Owner:
Bene:

Company Policy# IssueDt FaceAmount

Thanks in advance

 

[statsman]

I have tried to accomplish this same this on a number of occasions over the years, without success. I'm sure there must be a way to do it, but it has always eluded me.

Currently, I export the report in Excel format and just copy and past to the existing spreadsheet.

Not very sexy, but it works.

 

[ielamrani]

thank you.
I figured it's not easy to do since no one has given me an anwser. What I did so far is create a report and grouped it, exported it to excel. It's not the way i want it but it's close. Maybe it needs more programing.