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?
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?