AHow to append Access report data to an existing excel sheet?

[Bsteam]

Hi,
I heard good things about this site so I am trying it for the first and I am also new to Access so bear with me if i am not clear or I missed anything.

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

Bean

 

[TheAceMan1]

Howare ya Bsteam . . .

You can [blue]link[/blue] to the spreadsheet and treat it as an access table. There are a number of ways to update an access table . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886