Export to Excel target cells

[andyc209]

I want to export my query data to excel which is easy enough using OpenRowset, however i want to be able to target the data to specif cells eg

Query returns a value of money that i want to put in cell B5 in excel - can i target this cell with the result?

My code to post the results at the moment is

@SQL=N'INSERT INTO OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;HDR=YES;DATABASE='+@xlFileName+''',''Select * from [Sheet1$]'')SELECT money,interest,balance FROM tbl_cash'

 

[PWise]

Something like

''Select * from [Sheet1$]:A1''