[This topic is migrated from our old forums. The original author name has been removed]
Hi, I'm trying to run DBvisualizer to append the results to an Excel Spreadsheet. When I run it a second time, it just seems to override the previous cells. Any suggestions ? Thank you.
The following is the SQL that I execute:
@export set filename="\\xxxxxxx\Fsa\JimGormley\OHFS\OHFSsqlResults.xls" format='XLS' appendfile = "true";
where ch.adjudicationdate >= '01-mar-2009'
over 8 years ago
[This reply is migrated from our old forums.]
Re: Append SQL results to Excel Spreadsheet
I know it is a bit late...
The AppendFile option does not support appending rows to an existing Excel sheet. We have this on the todo list.