Exporting to Excel

[Dan Olsen]

We have a database in Access that we use to track information in one of our
programs we run here at work. When we tell Access to export to an Excel and
we tell it to overwrite the existing file it turns out that if just updates
the data in the main worksheet in the file. Is there a setting to get it to
completely remove the file and replace it instead of just updating that main
worksheet in the existing file?

 

[Gary Miller]

Dan,

You can always use the Kill statement before you do the
export to delete the old file.

Kill "c:\YourPath\YourFile.xls"

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________