[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 person has this question
1 Comment
Roger Bjärevall
said
about 13 years ago
[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
anonymous
1 person has this question