Export table to Excel weekly and start on first blank row
Posted on 2004-04-08
A table (TblExport) in my database needs to be exported to Excel weekly. The code I have now wants to add a new worksheet every time it is exported. Is there a way to have the data go on the same sheet every week to have it continuous? What code would I use? Or is there an easier/better way to achieve the same results?