I've read that their are ways to export a report from access -> excel without overwriting the file completely. Is this true? All the tutorials I've looked up have said nothing about it, and it always leaves me overwriting the file.
I need it to be exported to say, Sheet 2 of a given excel file, for example? Is that even possible?
I'm also trying to do this in a Macro as part of my automation process and I'm using office 2007.