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

ielamrani

Registered User.
Local time
Yesterday, 23:33
Joined
May 6, 2008
Messages
51
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

Active member
Local time
Yesterday, 23:33
Joined
Aug 22, 2004
Messages
2,088
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

Registered User.
Local time
Yesterday, 23:33
Joined
May 6, 2008
Messages
51
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.
 

Users who are viewing this thread

Top Bottom