Export table to Excel weekly and start on first blank row
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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.