Start a new topic

Append SQL results to Excel Spreadsheet

anonymous

started a topic about 14 years ago

[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

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

How can we help you today?

Append SQL results to Excel Spreadsheet

anonymous

Roger Bjärevall