Last post Jan 26, 2011 06:20 PM by Lorddog
Jan 26, 2011 06:20 PM|Lorddog|LINK
I have run up against so many walls in trying to write out to excel using sql.
I have 2 types of named ranges - single cell and multi cell that runs down a column.
i have been able to run "update range1 set F1 = ('my value')" when the range1 is a single cell.
I cannot run more then 1 insert into the range that is multi cell (down a column) the 2nd insert fails
I also found reading a sheet1$ gives me formated values but if i specify a range sheet1$A5:F20 then I get the underlying values (not the formated values)
my latest problem is that my update single cell named range works on my local but on my server it moves the named range to the right 3 cells with the data put in where it originally was. this using the update listed above. so i now tried to just insert directly
into a cell and cannot get the correct syntax.
I dont have a where clause and i dont have column names. I just have the location and sheet name (and my data)
update [Data$C5] set F1 = ('my data')
insert into [Data$C5] F1 values ('my data')
neither of these work and i cant figure out what i should be having there.