Start a new topic

Append SQL results to Excel Spreadsheet

[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 on; @export set filename="\\xxxxxxx\Fsa\JimGormley\OHFS\OHFSsqlResults.xls" format='XLS' appendfile = "true"; SELECT avg(ap.paymentdate-ch.claimreceiptdate)+6 FROM claimheader ch join aptransactionheader ap on ch.claimid=ap.claimid where ch.adjudicationdate >= '01-mar-2009' AND CH.ADJUDICATIONDATE
1 Comment

[This reply is migrated from our old forums.]

Re: Append SQL results to Excel Spreadsheet
Jim, 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. Thanks! Best Regards Roger