Append Access report data to an excel sheet?

  • Thread starter ielmrani via AccessMonster.com
  • Start date
I

ielmrani via AccessMonster.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top