Overwriting Excel Exported Data

[Chris Burke]

Hey Guys & Gals!

I need help with a query I have. I am dumping information
from my access 2000 database to an excel 2000 file using
the transferspreadsheet function.

What I was wondering was is there a way of overwriting the
existing data in the excel file instead of appending it?

Thanks,

This is such a great forum!

 

[Joe Fallon]

You can always use the Kill command to delete it prior to exporting.