i want to delete row in excel file from query because when i insert data in 2nd time, data is not insert in proper place for example
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\TestDB\first.xls;',
'SELECT cid, ClassName FROM [Sheet1$]')
SELECT cid, classname FROM Class
GO
now rows insert from top row, it's fine. now i want to execute this again. i want to delete old data and insert new data. for this purpose i use this query
update openrowset('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\TestDB\first.xls;',
'SELECT cid, ClassName FROM [Sheet1$]')
set cid=null,
classname=null
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\TestDB\first.xls;',
'SELECT cid, ClassName FROM [Sheet1$]')
SELECT cid, classname FROM Class
GO
Now insert from 60 row not in top row. I want to insert again in top row. i want to also delete and add sheet from query
please help thanks