Exporting to Excel

  • Thread starter Thread starter Dan Olsen
  • Start date Start date
D

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?
 
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
________________________
 
Back
Top